Home » SQL & PL/SQL » SQL & PL/SQL » sql+ vs pl/sql
sql+ vs pl/sql [message #1252] Mon, 15 April 2002 04:56 Go to next message
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 Go to previous message
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
Previous Topic: Re: Inserting a rowtype variable into a table
Next Topic: how can transfer a column into a row with a single SELECT?
Goto Forum:
  


Current Time: Thu Mar 28 13:04:55 CDT 2024