Return no value from a view
(2009-03-13 13:27:06)
下一個
When excute a SQl statement to retrive data from a view in SQL*PLUS, the query returns 'no data selected'. Actually there is data in the view.
For example, select * from ap_invoice_distributions_v;
Answer: the environment variable should be set by executing the below statement:
execute dbms_application_info.set_client_info('org id');
If for certain operating unit, the org_id = 1252, the statement would be:
execute dbms_application_info.set_client_info(1252);
After this, excute the query to retrive data from the view, there should be results returned.