8 Replies Latest reply: Dec 27, 2013 7:55 AM by vishal waghole RSS

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

    Frank Peng

      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