Home » SQL & PL/SQL » SQL & PL/SQL » Job scheduler - SQL Error ORA-06550 (Oracle 10g EM)
Job scheduler - SQL Error ORA-06550 [message #342564] Fri, 22 August 2008 16:25 Go to next message
lsalih
Messages: 2
Registered: August 2008
Junior Member
Hi -

I am new to using Oracle, I am trying to run a simple SQL command using job scheduler. When I ran the command, I get below error message:

Details ORA-06550: line ORA-06550: line 2, column 7: PLS-00103: Encountered the symbol "C" when expecting one of the following: := . ( @ % ; , column :

*** Here is what I have under Command box ****
begin
spool c:\test1.txt
select lastname from test where lastname like 'TEST%'
spool off
end;

Thanks for your help.
Re: Job scheduler - SQL Error ORA-06550 [message #342566 is a reply to message #342564] Fri, 22 August 2008 16:39 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
PL/SQL <> SQL*Plus

SPOOL is a SQL*plus command & not valid in PL/SQL.
Re: Job scheduler - SQL Error ORA-06550 [message #342567 is a reply to message #342564] Fri, 22 August 2008 16:47 Go to previous messageGo to next message
lsalih
Messages: 2
Registered: August 2008
Junior Member
May I ask you how you save output to a file.

All I need is to create a text file to save the output, that is the purpose of running the scheduler.

Thanks.
Re: Job scheduler - SQL Error ORA-06550 [message #342568 is a reply to message #342564] Fri, 22 August 2008 16:49 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above


DBMS_OUTPUT or UTL_FILE depending upon the requirements.
You need to learn to Read The Fine Manual to find answers.
Previous Topic: Wrong number or types of arguments error
Next Topic: calculate the max and sum value by weird way !!!
Goto Forum:
  


Current Time: Fri Dec 09 15:23:04 CST 2016

Total time taken to generate the page: 0.18461 seconds