忙裏偷閑

很多事情很多心情寫了也就記下了; 不寫,以後可能就忘了.
個人資料
正文

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)
評論
目前還沒有任何評論
登錄後才可評論.