Thanks for the question, Hans.
Asked: September 30, 2024 - 3:43 pm UTC
Last updated: October 01, 2024 - 1:29 pm UTC
Version: 19c
Viewed 1000+ times
declare procedure test_stmt ( stmt varchar2 ) as cur int; begin dbms_output.put_line ( 'Testing statment ' || stmt ); cur := dbms_sql.open_cursor; dbms_sql.parse ( cur, stmt, dbms_sql.native ); dbms_sql.close_cursor ( cur ); end; begin test_stmt ( 'select count(*) from hr.employees' ); test_stmt ( 'select count(*) from junk_table' ); end; / Testing statment select count(*) from hr.employees Testing statment select count(*) from junk_table ORA-00942: table or view "CHRIS"."JUNK_TABLE" does not exist
Hans Looyschelder, September 30, 2024 - 5:40 pm UTC
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library