Oracle error ORA-22905: cannot access rows from a non-nested table item
Creating a report using oracle plsql code .
Getting error ;
when I am trying to pass data in clause in pl sql proc
basically I have a proc which takes 2 parameters(a and b) as input for execution
--where id in (
-- SELECT * FROM THE (SELECT p_cd_common.get_table_from_string(P_a) FROM dual)
-- SELECT * FROM THE (SELECT p_cd_common.get_table_from_string(P_b) FROM dual)
data sample returned from this :SELECT * FROM THE (SELECT p_cd_common.get_table_from_string(P_a) FROM dual)
data sample returned from this;SELECT * FROM THE (SELECT p_cd_common.get_table_from_string(P_b) FROM dual)
Any answers ?
How to pass data in clause in a better way
Thank you for your post.
Since the issue is related to Oracle. It is out of the support boundaries of our forum, I recommend you post your questions to Oracle forum. It is appropriate and more experts will assist you.
There are some similar threads, you can refer to it.
Hope this helps.
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?