CODEWITHSUNDEEP
sqloracle-databaseoracle10g
Dinesh Suthar
Dinesh Suthar

Reputation: 880

Error: ORA-06550 in Oracle 10g

Here i have created a package,with package specification and package body,which contains a procedure which insert a row in table,package creation is successful but execution of that package is giving me error

ORA-06550

Package specification:

create or replace package pkgEmp --package specification created..
as
procedure insertEmp(eno number,name varchar2,job varchar2,mgr varchar2,salary number);
end pkgEmp;

package body:

create or replace package body pkgEmp
as
procedure insertEmp(eno number,name varchar2,job varchar2,mgr varchar2,salary number)
is
begin
insert into emp values(eno,name,job,mgr,salary);
end insertEmp;
end pkgEmp;

Exeuting procedure insertEmp:

begin
pkgEmp.insertEmp(&eno,&name,&job,&mgr,&salary); --i m trying to get data in run time.
End;

and output:

ORA-06550: line 2, column 18:
PLS-00103: Encountered the symbol "&" when expecting one of the following:

   ( ) - + case mod new not null others 

   table avg count current exists max min prior sql stddev sum
   variance execute multiset the both leading trailing forall
   merge year month DAY_ hour minute second timezone_hour
   timezone_minute timezone_region timezone_abbr time timestamp
   interval date


1. begin
2. pkgEmp.insertEmp(&eno,&name,&job,&mgr,&salary);
3. End;

Why I am not able to get data from User,I m using SQL*Plus

Upvotes: 0

Views: 5201

Answers (1)

Aditya Kakirde
Aditya Kakirde

Reputation: 5225

I think you need to put parameters in 'single quotes' like '&name' where the datatype is non-integer.

Thanks, Aditya

Upvotes: 1

Related Questions