sql+ vs pl/sql [message #1252] |
Mon, 15 April 2002 04:56 |
LC
Messages: 3 Registered: April 2002
|
Junior Member |
|
|
i am trying to use sql+ commands like:
set heading off
set pagesize 00
set feedback off
spool u:employerhighcost.txt;
within a pl/sql block and get an error message. these work by themselves in a script, but not in the block structure. is there a way to get this to work? thanks.
-- lc
|
|
|
Re: sql+ vs pl/sql [message #1253 is a reply to message #1252] |
Mon, 15 April 2002 05:18 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
Hi,
Sqlplus is an application used to connect to the database. Sqlplus commands can only be used when you are using the client application Sqlplus (or any other tools supporting the same commands). These commands are interpreted by the Sqlplus application itself and in many cases doesn't have any relation to the database.
So the answer to your question is no, there is no way to get this to work. Sqlplus commands can not be used in PLSQL you have to use SQL or PLSQL to get your work done.
Hope that helps
Mike
|
|
|