Home » SQL & PL/SQL » SQL & PL/SQL » Error executing statement: ORA-06550 (Widnows 2000)
Error executing statement: ORA-06550 [message #394498] Fri, 27 March 2009 08:16 Go to next message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
I am trying to execute:
EXEC TEST_MAIL
(
'abc@mail.com',
'xyz@mail.com',
'xyz@mail.com', 
'PE',
'Th'
);


but getting the following error:

Error executing statement: ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:

   := . ( @ % ;
The symbol ";" was substituted for "END" to continue
Re: Error executing statement: ORA-06550 [message #394500 is a reply to message #394498] Fri, 27 March 2009 08:19 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
It would appear that you have an error in your code. Probably better to fix the error in your code. I would suggest that you start looking around line 3 of your procedure.
Re: Error executing statement: ORA-06550 [message #394501 is a reply to message #394498] Fri, 27 March 2009 08:22 Go to previous messageGo to next message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
i don't think there is any problem with the procedure because its working fine at other places as well.
Re: Error executing statement: ORA-06550 [message #394503 is a reply to message #394498] Fri, 27 March 2009 08:27 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
The code you've posted can't give that error.
The error is a compile error, a procedure call can't give a compile error
Re: Error executing statement: ORA-06550 [message #394505 is a reply to message #394503] Fri, 27 March 2009 08:49 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Does Test_Mail have any dynamic pl/sql in it?

What does 'SELECT * FROM ALL_ERRORS WHERE NAME = 'TEST_MAIL';' return?
Re: Error executing statement: ORA-06550 [message #394509 is a reply to message #394498] Fri, 27 March 2009 09:25 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
As EXECUTE is SQL*Plus command, I suppose you use this tool. Its behaviour is documented in SQL*PlusĀ® User's Guide and Reference, available with other Oracle documentation books e.g. online on http://tahiti.oracle.com/.

For Oracle 10gR2 it is located here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12022.htm#i2697931
Quote:
If your EXECUTE command cannot fit on one line because of the PL/SQL statement, use the SQL*Plus continuation character (a hyphen).

SQL> set serveroutput on
SQL> exec dbms_output.put_line
BEGIN dbms_output.put_line; END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

SQL> exec dbms_output.put_line -
> ( -
>  'aaa' -
> );
aaa

PL/SQL procedure successfully completed.

I have no idea why the error I got is different from yours; however, as you did not post what you exactly did (within the SQL*Plus response), it is hard to say more.
Re: Error executing statement: ORA-06550 [message #394572 is a reply to message #394498] Fri, 27 March 2009 17:10 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
PLS-00103 errors are syntax errors in PL/SQL code. Check your code's syntax.




Select * from user_errors where name='yourprocedurename';


your procedure name should be in upper case...


Run the above query giving the name of the procedure in the query.


Regards,
Oli




[Updated on: Fri, 27 March 2009 17:11]

Report message to a moderator

Previous Topic: URGENT: ORA-24778 - Cannot open connections error
Next Topic: Joining one little and one big table. Noob question.
Goto Forum:
  


Current Time: Sun Dec 04 20:24:19 CST 2016

Total time taken to generate the page: 0.05583 seconds