Re: Errors ORA-06550 and PLS-00306 in Procedure

Could you show source code, where you calling this procedure?

<april.mcclellan_at_HydroOne.com> wrote in message news:2F96BE4C7CC6D211A55F0008C7A43976017424C0_at_OHSC-EX4...
> 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.ORG
Received on Thu Mar 08 2001 - 10:49:43 CST