Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi frank,
I think, we cant able to call that packages from QlikView.
- Regards,
Vishal Waghole
Hi frank,
Create a view in Oracle and then fetch the record from this view.
select * from <ViewName>.
Regards
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
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
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
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
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
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