OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00103

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

PLS-00103 [message #305499]

Tue, 11 March 2008 01:32

sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India

Member

I'm getting error while executing below package please suggest Shocked

create or replace package bonus is g_max_bonus :=.99;
function calc_bonus(p_emp_id number)
return number;
function calc_salary(p_emp_id number)
return number;
end;
/

ng: Package created with compilation errors.

show errors;
s for PACKAGE BONUS:

COL ERROR
--- -----------------------------------------------------------------
PLS-00103: Encountered the symbol "=" when expecting one of the
following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue.

Report message to a moderator

Re: PLS-00103 [message #305502 is a reply to message #305499]

Tue, 11 March 2008 01:41

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is the type of "g_max_bonus"?

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: PLS-00103 [message #305504 is a reply to message #305502]

Tue, 11 March 2008 01:43

sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India

Member

datatype is number

Report message to a moderator

Re: PLS-00103 [message #305510 is a reply to message #305499]

Tue, 11 March 2008 02:07

kecd_deepak
Messages: 52
Registered: December 2007

Member

You didn't provide data type for variable g_max_bonus.

create or replace package bonusq is
g_max_bonus NUMBER :=.99;
function calc_bonus(p_emp_id number)
return number;
function calc_salary(p_emp_id number)
return number;
end;
/

Report message to a moderator