Home » SQL & PL/SQL » Client Tools » Exeuting stored procedure in SQLDeveloper (version1.1.3)
Exeuting stored procedure in SQLDeveloper [message #435403] Wed, 16 December 2009 02:42 Go to next message
amolpalekar
Messages: 1
Registered: December 2009
Junior Member
Hi,
I am learning pl/sql. I have written stored procedure using out mode.
I am unable to execute this procedure in sqldeveloper.
Please find the code of plsql below

CREATE OR REPLACE
PROCEDURE ADD_STUDENT
( p_fname in student.FNAME%type,
p_lname student.LNAME%type,
p_city student.CITY%type,
p_rollno out student.ROLLNO%type
)
AS
v_rollno integer;
BEGIN
select max(rollno) into v_rollno from student;
p_rollno:=v_rollno+1;
insert into student(rollno,fname,lname,city)
values
(p_rollno,p_fname,p_lname,p_city);
dbms_output.PUT_LINE('Row Inserted');
END;

Q1)Please find error screen shot attached when i try to execute this stored procedure?
Re: Exeuting stored procedure in SQLDeveloper [message #435405 is a reply to message #435403] Wed, 16 December 2009 02:50 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your procedure has 4 parameters, you call it with 3, so the error.

Regards
Michel
Previous Topic: How to spool the data of a clob or long column
Next Topic: change isqlplus GUI write area
Goto Forum:
  


Current Time: Sun Dec 04 02:55:33 CST 2016

Total time taken to generate the page: 0.11179 seconds