Error........... [message #229214] |
Fri, 06 April 2007 01:13 |
pravinmgawande
Messages: 3 Registered: March 2007
|
Junior Member |
|
|
Hi All ,
I wrote one procedure with name "temp_level_approver_id"
but when i'm calling this procedure it gives me error like
Encountered the symbol "temp_level_approver_id" when expecting one of the following:
and below some symbols were there like :=,")"....
If anybody knows how to solve this problem
Thanks in Advance
Regards
- Pravin
|
|
|
|
|
|
|
|
Re: Error........... [message #229336 is a reply to message #229333] |
Fri, 06 April 2007 12:20 |
|
ebrian
Messages: 2794 Registered: April 2006
|
Senior Member |
|
|
Michel Cadot wrote on Fri, 06 April 2007 13:05 |
There is no relation with how the procedure is called.
The procedure itself is wrong.
|
Unless the OP did something like:
SQL> create procedure test_proc
2 is
3 begin
4 dbms_output.put_line('Test');
5 end;
6 /
Procedure created.
SQL> exec test_proc test_proc
BEGIN test_proc test_proc; END;
*
ERROR at line 1:
ORA-06550: line 1, column 17:
PLS-00103: Encountered the symbol "TEST_PROC" when expecting one of the
following:
:= . ( @ % ;
The symbol ":=" was substituted for "TEST_PROC" to continue.
SQL> exec test_proc
Test
PL/SQL procedure successfully completed.
Of course, my crystal ball is broken today, so I can't determine that.
[Updated on: Fri, 06 April 2007 16:16] Report message to a moderator
|
|
|
Re: Error........... [message #229369 is a reply to message #229333] |
Sat, 07 April 2007 00:53 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Michel Cadot wrote on Fri, 06 April 2007 19:05 |
There is no relation with how the procedure is called.
The procedure itself is wrong.
Regards
Michel
|
If what the OP told us is correct, the problem IS in the way the procedure is called:
SQL> create or replace procedure i_got_errors
2 as
3 begin
4 i got errors;
5 emd;
6 /
Warning: Procedure created with compilation errors.
SQL> show errors
Errors for PROCEDURE I_GOT_ERRORS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/5 PLS-00103: Encountered the symbol "GOT" when expecting one of the
following:
:= . ( @ % ;
5/4 PLS-00103: Encountered the symbol "end-of-file" when expecting
one of the following:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe
SQL> begin
2 i_got_errors;
3 end;
4 /
i_got_errors;
*
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00905: object SCOTT.I_GOT_ERRORS is invalid
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
pravinmgawande wrote | I wrote one procedure with name "temp_level_approver_id"
but when i'm calling this procedure it gives me error like
Encountered the symbol "temp_level_approver_id" when expecting one of the following:
|
See? The call to the procedure gave an error.
I showed that a valid call to an invalid procedure returns another error then PLS-00103
|
|
|
|
Re: Error........... [message #229468 is a reply to message #229464] |
Sun, 08 April 2007 12:52 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
And the problem and solution was?
You got help from us, it'd be nice to share the solution.
Regards
Michel
|
|
|