Home » Other » Test » Problem with stored procedures
Problem with stored procedures [message #263835] Fri, 31 August 2007 02:44 Go to next message
zama
Messages: 3
Registered: August 2007
Junior Member
Hi, guys I need help I created a stored procedure here it is:

CREATE OR REPLACE PROCEDURE ADD_USER
(LStaffNo IN LECTURER.STAFFNO % TYPE,LUsername IN LECTURER.USERNAME %TYPE, LPassword IN LECTURER.PASSWORD % TYPE,LName IN LECTURER.NAME % TYPE, LSurname IN LECTURER.SURNAME % TYPE )
IS
BEGIN
INSERT INTO LECTURER VALUES(LStaffNo, LUsername, LPassword, LName, LSurname);
END ADD_USER;

and it was successfully created. But when I execute it it just give me this error:

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'ADD_USER'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

I dont know what to do anymore coz my whole application depends on this.



Re: Problem with stored procedures [message #263842 is a reply to message #263835] Fri, 31 August 2007 02:58 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
You are aware that you posted this in the Test-forum?
This forum is meant for testing how to post; not for asking questions. If you want an answer to this question, better post it again in the SQL & PL/SQL Newbies forum.

And if you decide to do so, add a copy-paste of the code you use to call the procedure

[Updated on: Fri, 31 August 2007 02:58]

Report message to a moderator

Re: Problem with stored procedures [message #263847 is a reply to message #263842] Fri, 31 August 2007 03:05 Go to previous messageGo to next message
zama
Messages: 3
Registered: August 2007
Junior Member
Thank you I'll try just that
Re: Problem with stored procedures [message #263856 is a reply to message #263847] Fri, 31 August 2007 03:30 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you post:
Follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Lord of the stickies - (c) Littlefoot
Next Topic: e
Goto Forum:
  


Current Time: Fri Mar 29 06:44:10 CDT 2024