| Problem with stored procedures [message #263835] |
Fri, 31 August 2007 02:44  |
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  |
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 #263856 is a reply to message #263847] |
Fri, 31 August 2007 03:30 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
