how to show sql statements in pl/sql

[donnie_xu]

hi,
I am debuging a shell in unix, which contains pl/sql used to purge some data in oracle db.
I want show a sql statemnet (a select statement) in it when executing it?
How can i?
Thanks in advance

[jametong]

in sqlplus 执行命令set termout on echo on;

[LGQDUCKY]

用DBMS_OUTPUT.PUT_LINE 例如：

DBMS_OUTPUT.PUT_LINE('PK_TAB_NAME0='||pk_table_name||',ret='||ret);

[LGQDUCKY]

或者用PLSQL Developer工具
可以看到当前执行的SQL语句。。。