Skip to Main Content

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!

Simple echo, or print in SQLPlus ?

223563Jun 24 2004 — edited Jun 25 2004
Hi:

I'm running an sql script for which I would like to echo the commands being run. What I'm looking for would be similar to "set verify" in the SQL interface for Oracle-RDB. Barring that, a simpe way to "echo" a simple literal would suffice. I used to use "select 'foo' from dual;", but that doesn't always work....

SQL> select 'mml_gdcp8rf020_easx070' from dual;
select 'mml_gdcp8rf020_easx070' from dual
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17182], [1075506792], [], [], [], [], [], []

Is there a different way to do this?




Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2004
Added on Jun 24 2004
4 comments
2,576 views