topic Re: Running a select query from Oracle standard view returns 0 record in Qlikview in QlikView

Running a select query from Oracle standard view returns 0 record in Qlikview

Wed, 25 Dec 2013 02:59:11 GMT

Hello everyone,

I am just facing this problem: running a select query from an standard Oracle view in TOAD can return records as expected after running the below script in TOAD:

VARCHAR2(50):='AMERICAN'; --'SIMPLIFIED CHINESE';

v_language_option VARCHAR2(500);

begin

:= 'ALTER SESSION SET NLS_LANGUAGE= ''' ||

|| '''';

EXECUTE IMMEDIATE (v_language_option); --???????

fnd_global.apps_initialize(user_id => 1230, resp_id => 50541, resp_appl_id => 200);

mo_global.set_policy_context('S', '81');

end;

but it can't return any record to run a select query from an standard Oracle view in Qlikview; of course I did not run that script in Qlikview as i don't know how to run it.

Anybody can help this out?

Appreciate your help.

Thanks,

Frank

Re: Running a select query from Oracle standard view returns 0 record in Qlikview

VishalWaghole — Thu, 26 Dec 2013 04:30:44 GMT

Hi frank,

I think, we cant able to call that packages from QlikView.

- Regards,

Vishal Waghole

Re: Running a select query from Oracle standard view returns 0 record in Qlikview

senpradip007 — Thu, 26 Dec 2013 07:46:12 GMT

Hi frank,

Create a view in Oracle and then fetch the record from this view.

select * from <ViewName>.

Regards

Re: Running a select query from Oracle standard view returns 0 record in Qlikview

Anonymous — Thu, 26 Dec 2013 08:46:06 GMT

Qlikview only support Select statements for any database.

For executing procedures, call is used, but I have doubt to call a package from Qlikview.

Optimized resolution is to have a view for the same and then use following:

SQL select * from view_name;

Regards

Nitin

Re: Running a select query from Oracle standard view returns 0 record in Qlikview

stevedark — Thu, 26 Dec 2013 08:48:41 GMT

You may find that batching all of those statements up into a stored

procedure and calling that will work as you require.

You will need to set the script options to allow write (QlikView assumes

any stored procedure may write to the database).

You should find instructions for this if you search the community.

Good luck

Steve

Re: Running a select query from Oracle standard view returns 0 record in Qlikview

Fri, 27 Dec 2013 02:00:00 GMT

thanks, everyone.

The query I am trying to run is as follows:

---------

select MD.ORGANIZATION_CODE,MD.ITEM_SEGMENTS,MD.ITEM_DESCRIPTION,MD.PLAN_ID,

MD.CATEGORY_SET_ID,MD.CATEGORY_ID,MD.CATEGORY_NAME,

MD.QUANTITY, MD.EXCEPTION_TYPE_TEXT,MD.FROM_DATE,MD.TO_DATE

from MSC_EXCEPTION_DETAILS_V MD

where MD.PLAN_ID = 1

and MD.EXCEPTION_TYPE_TEXT='Items with excess inventory'

and MD.CATEGORY_SET_ID=9

----------

MSC_EXCEPTION_DETAILS_V is a seeded view in Oracle.

when removing MD.EXCEPTION_TYPE_TEXT='Items with excess inventory', it's working fine.

Anyone does have any inputs for local machine setup?

Thanks,

Frank

Re: Running a select query from Oracle standard view returns 0 record in Qlikview

VishalWaghole — Fri, 27 Dec 2013 04:49:50 GMT

Hi frank,

Check whether their is any record for 'Items with excess inventory'.

if no any record for such value then it will return zero record.

- Regards,

Vishal Waghole

Re: Running a select query from Oracle standard view returns 0 record in Qlikview

stevedark — Fri, 27 Dec 2013 09:04:56 GMT

Try without the WHERE statement and then after load add a list box to the

screen containing MD.EXCEPTION_TYPE_TEXT. This will show you all values for

this field. Find the list box entry and check it matches your WHERE

statement. You can right click it and select 'Copy Cell Value' and paste it

into your load script.

If that value doesn't exist then you have found your problem. I would then

head back to the database to investigate. Or you could comment out the

other two WHERE statements to check three full table contents in QlikView.

Hope that helps,

Steve

Re: Running a select query from Oracle standard view returns 0 record in Qlikview

VishalWaghole — Fri, 27 Dec 2013 12:55:07 GMT

Hi frank,

I think this is Globle View, that does not contain any data,

Data will be populated only for perticular session.

Better do one thing, Check base tables on which view is created.

and also use that base table for QlikView.

Hope that will solve your problem.

- Regards,

Vishal Waghole