Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

execute immediate dynamic sql statements

user5108636Feb 13 2019 — edited Feb 18 2019

Hi All,

     Using Oracle 12c. I run dynamic sql within plsql using the execute immediate statement. However, at times the dynamic sql may not have a valid table in the query. I may need to check if the table is valid before I run the dynamic sql.

Please advise how carry out that check programmatically using PLSQL. Or is it possible to wrap the execute immediate statement  to handle such exceptions. Please advise

Thanks

Comments
Post Details
Added on Feb 13 2019
12 comments
1,554 views