-
Error when Compiling a Stored Procedure
Hello, I have written a stored procedure which compiles with the error message:
PL/SQL: ORA-00922: missing or invalid option
If I execute the script in Toad, it works. Below is the script
SET ECHO OFF
SET FEEDBACK OFF
SET SPACE 0
SET LINESIZE 2000
SET PAGESIZE 0
SET VERIFY OFF
SET HEADING ON
SET COLSEP |
spool 'C:\Output_to_flat_file.txt'
select * from T_TMP;
SPOOL OFF
any ideas?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|