OraFAQ Forum: SQL & PL/SQL » Job scheduler

Home » SQL & PL/SQL » SQL & PL/SQL » Job scheduler - SQL Error ORA-06550 (Oracle 10g EM)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Job scheduler - SQL Error ORA-06550 [message #342564]

Fri, 22 August 2008 16:25

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.

Report message to a moderator

Re: Job scheduler - SQL Error ORA-06550 [message #342566 is a reply to message #342564]

Fri, 22 August 2008 16:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

PL/SQL <> SQL*Plus

SPOOL is a SQL*plus command & not valid in PL/SQL.

Report message to a moderator

Re: Job scheduler - SQL Error ORA-06550 [message #342567 is a reply to message #342564]

Fri, 22 August 2008 16:47

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.

Report message to a moderator

Re: Job scheduler - SQL Error ORA-06550 [message #342568 is a reply to message #342564]

Fri, 22 August 2008 16:49

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	Wrong number or types of arguments error
Next Topic:	calculate the max and sum value by weird way !!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 07 01:04:59 CDT 2026