Home » SQL & PL/SQL » SQL & PL/SQL » SPOOL IN PL/SQL BLOCK
SPOOL IN PL/SQL BLOCK [message #421846] Fri, 11 September 2009 01:51 Go to next message
sen_sam86
Messages: 33
Registered: August 2009
Location: Chennai
Member
IS IT POSSIBLE TO USE SPOOL INSIDE PL/SQL BLOCK LIKE THIS 

DECLARE 
SPOOL C:\TEST1.TXT
V_TEMP VARCHAR2(10);
  BEGIN 
    SELECT 'HAI' INTO v_temp FROM DUAL;
  END;

AM GETTING ERROR 
ORA-06550: line 2, column 8:
PLS-00103: Encountered the symbol ":" when expecting one of the following:
Re: SPOOL IN PL/SQL BLOCK [message #421847 is a reply to message #421846] Fri, 11 September 2009 02:04 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

And do not post in UPPER case.

Regards
Michel
Previous Topic: How to get profiler report
Next Topic: confusion in passing parameters to function
Goto Forum:
  


Current Time: Tue Dec 06 12:25:31 CST 2016

Total time taken to generate the page: 0.13864 seconds