Marco Kalter Administrator Staff member Nov 8, 2006 #1 What exactly goes wrong? What is the value of v_sql?
C CTzen Member³ Nov 8, 2006 #1 It works for me Code: SQL> declare l_sql varchar2(30) := 'select * from dual'; begin dbms_output.put_line('SQL: '||l_sql); end; / SQL: select * from dual PL/SQL procedure successfully completed Executed in 0.578 seconds SQL>
It works for me Code: SQL> declare l_sql varchar2(30) := 'select * from dual'; begin dbms_output.put_line('SQL: '||l_sql); end; / SQL: select * from dual PL/SQL procedure successfully completed Executed in 0.578 seconds SQL>
R rpillot Member Nov 9, 2006 #1 Shame on me !!! All is going well, now. thanks Marko, CTzen. For information, v_sql is a query, and a wrong query, and in my exception bloc, I wrote nothing so no output !!! Sorry. Best regards. R.PILLOT
Shame on me !!! All is going well, now. thanks Marko, CTzen. For information, v_sql is a query, and a wrong query, and in my exception bloc, I wrote nothing so no output !!! Sorry. Best regards. R.PILLOT