re: undefine ... error

[hreddy007]

hi! ,

I have a file xyz.sql

In that file I have three undefine statments at the begining ..

undefine a
undefine b
undefine c

create ...
etc

When I open the file from SQL*PLUS and issue the
/ command to run the contents of the file
it is giving error
------------------------------------------------------
SQL> ed
Wrote file afiedt.buf

1 undefine a
2 undefine b
3* undefine c
4 /
undefine a
*
ERROR at line 1:
ORA-00900: invalid SQL statement


SQL>
--------------------------------------------------------

What is the reason for this error and how do I get rid of this
error ?
I want to be able run the file with the undefine commands in it ..!!!

thanks for your help !!!!

[akhadar]

check this link
http://metalink.oracle.com/metalink/...p_id=1035193.6

[hreddy007]

sorry!!! but i do not have a metalink id ...
Please refer me to any other documentation or information


thanks

[reydp]

using ed is treated as a single command, therefore you should save your undefined commands in one txtfile and execute it using START or @ as what the link of akhadar suggested.