Dbms_output.put_line with variables

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>
 
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
 
Back
Top