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

[#1]

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

[VishalWaghole]

Hi frank,

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

- Regards,

Vishal Waghole

[senpradip007]

Hi frank,

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

select * from <ViewName>.

Regards

[Anonymous]

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

[stevedark]

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

[#6]

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

[VishalWaghole]

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

[stevedark]

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

[VishalWaghole]

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