Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Errors ORA-06550 and PLS-00306 in Procedure

Errors ORA-06550 and PLS-00306 in Procedure

From: <april.mcclellan_at_HydroOne.com>
Date: 8 Mar 2001 17:31:19 +0100
Message-ID: <2F96BE4C7CC6D211A55F0008C7A43976017424C0@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:31:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US