忙里偷闲

很多事情很多心情写了也就记下了; 不写,以后可能就忘了.
个人资料
正文

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.




[ 打印 ]
阅读 ()评论 (1)
评论
目前还没有任何评论
登录后才可评论.