Home » SQL & PL/SQL » SQL & PL/SQL » Error...........
Error........... [message #229214] Fri, 06 April 2007 01:13 Go to next message
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 #229217 is a reply to message #229214] Fri, 06 April 2007 01:28 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

you did not give us the information to tell you what is actually wrong.
please do post your procedure along with the error message.

regards
shanth.
Re: Error........... [message #229221 is a reply to message #229214] Fri, 06 April 2007 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

You have a syntax error.

Regards
Michel
Re: Error........... [message #229281 is a reply to message #229214] Fri, 06 April 2007 08:02 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I would put in one of the symbols :=,")".... like it says.

[Updated on: Fri, 06 April 2007 08:02]

Report message to a moderator

Re: Error........... [message #229330 is a reply to message #229214] Fri, 06 April 2007 11:55 Go to previous messageGo to next message
dba_bng
Messages: 13
Registered: April 2007
Junior Member
Can you please post the way you are calling the procedure? I need the exact statement.
Re: Error........... [message #229333 is a reply to message #229330] Fri, 06 April 2007 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

There is no relation with how the procedure is called.
The procedure itself is wrong.

Regards
Michel
Re: Error........... [message #229336 is a reply to message #229333] Fri, 06 April 2007 12:20 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #229464 is a reply to message #229214] Sun, 08 April 2007 10:14 Go to previous messageGo to next message
pravinmgawande
Messages: 3
Registered: March 2007
Junior Member

Hi All ,


I got the solution for the prolem , thanks a lot for ur replys.



Ragards
- Pravin
Re: Error........... [message #229468 is a reply to message #229464] Sun, 08 April 2007 12:52 Go to previous message
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

Previous Topic: how does a cursor work?
Next Topic: ways to load time dimension
Goto Forum:
  


Current Time: Tue Dec 03 15:23:01 CST 2024