Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Errors ORA-06550 and PLS-00306 in Procedure
Can anyone tell me what is wrong with this Procedure?
I get the message "wrong number or types of arguments in call to ...". However, I have verified and reverified that the values inserted are the correct datatype, in the correct order as well as being the correct number of arguments.
I wonder if it has something to do with the sequence? I have manually inserted data into the table referenced below to verify that the trigger works.
CREATE OR REPLACE PROCEDURE SPSAVESTATUSCHANGES (
p_CONTPREFIX IN Varchar2, p_CONTYR IN Varchar2, p_CONTSLANUM IN Varchar2, p_CONTSLAVERSION IN Varchar2, p_CONTAWDNUM IN Varchar2, p_NMPROJNO IN Varchar2, p_PROJECTREVNO IN Number, p_STATUS IN Varchar2, p_DIVISION IN Varchar2, p_USER IN Varchar2, p_DATE IN Date)
IS
BEGIN
INSERT INTO tblStatusChanges VALUES
(SEQ_TBLSTATUSCHANGES.nextval,p_CONTPREFIX,p_CONTYR,p_CONTSLANUM,
p_CONTSLAVERSION,p_CONTAWDNUM, p_NMPROJNO, p_PROJECTREVNO, p_DIVISION, p_STATUS, p_USER, p_DATE);
COMMIT;
EXCEPTION WHEN OTHERS THEN ROLLBACK; RAISE;
END SPSAVESTATUSCHANGES; Thanks for your help,
April McClellan
Internet: mailto:April.McClellan_at_hydroone.com
-- Posted from thor.hydroone.com [192.75.116.12] via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Thu Mar 08 2001 - 10:31:19 CST
![]() |
![]() |