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!

Parse DDL and DML statement

samujjwalbasuNov 20 2006 — edited Nov 20 2006

Hi,

I have a requirement to validate dynamic sql statement is valid or not, the sql statement may be DML or DDL. I can use dbms_sql.parse, it works fine for the DML, but it doesnt work for the DDL statetment because instead of testing it actually execute the statement.

Does anybody have any idea how to test the validity of sql statement?

Thanks in advance.

Regards,

Samujjwal Basu

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2006

Added on Nov 20 2006

4 comments

1,042 views