Home » SQL & PL/SQL » SQL & PL/SQL » pls-00103 (merged)
pls-00103 (merged) [message #407136] Mon, 08 June 2009 11:39 Go to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
CREATE OR REPLACE PACKAGE pkg_1
AS
-- start
PROCEDURE myp(out_rows); 

END;
/

CREATE OR REPLACE PACKAGE BODY pkg_1
AS
-- 1
PROCEDURE myp (out_rows OUT NUMBER)
IS

BEGIN
-- delete stmt
v_cnt:= sql%rowcount;
out_rows := v_cnt;
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
blah blah
END myp;


i am getting pls-00103 error when running spec

[Updated on: Mon, 08 June 2009 11:47] by Moderator

Report message to a moderator

Re: pls-00103 [message #407138 is a reply to message #407136] Mon, 08 June 2009 11:46 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>i am getting pls-00103 error when running spec
Point of order!
PLS is a compile time error NOT a run time error.

You need to provide correct syntax before trying to run code.
Re: pls-00103 (merged) [message #407139 is a reply to message #407136] Mon, 08 June 2009 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste your call.

Quote:
PLS-00103: %s
Cause: This error message is from the parser. It found a token (language element) that is inappropriate in this context.
Action: Check previous tokens as well as the one given in the error message. The line and column numbers given in the error message refer to the end of the faulty language construct.



As BlackSwan's said it is a compile time error not an execution one.

Regards
Michel
Re: pls-00103 (merged) [message #407181 is a reply to message #407136] Mon, 08 June 2009 23:57 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
ora1980 wrote on Mon, 08 June 2009 18:39
Spec:
PROCEDURE myp(out_rows); 

Body:
PROCEDURE myp (out_rows OUT NUMBER)




Let's play Spot The Difference!
Re: pls-00103 (merged) [message #407182 is a reply to message #407136] Mon, 08 June 2009 23:59 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You can lead some folks to knowledge,but you can't make them think!
Previous Topic: executing a select on two tables and getting the updated only
Next Topic: Formatting using UTL_FILE package
Goto Forum:
  


Current Time: Thu Dec 08 18:27:43 CST 2016

Total time taken to generate the page: 0.10924 seconds