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

Glen_D
Glen_D used Ask the Experts™
on
we have this sp that will return a result set...below.  When my CF developer make sthe call, he is getting the error in the title...any ideas? Thx and this is urgent for us...

CREATE or REPLACE package PACK_ISREFCUR_ARRAY AS      
TYPE refcArray IS REF CURSOR RETURN LU_State%ROWTYPE ;  
PROCEDURE PROC_ISREFCUR_ARRAY (outLU_State OUT refcArray) ;
END ;
/

CREATE OR REPLACE package body PACK_ISREFCUR_ARRAY AS  
PROCEDURE PROC_ISREFCUR_ARRAY (outLU_State OUT refcArray) IS    
BEGIN      
OPEN outLU_State FOR
SELECT StateID, State_Desc, State_AB
FROM LU_State
ORDER BY State_Desc;    
END ;
END ;
/
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
can you post the cf code... if the proc runs for you but not the cf dev, then it's a cf code issue most likely

Author

Commented:
Thx...here's the CF code:

<cfstoredproc datasource="ericao" procedure="PACK_ISREFCUR_ARRAY.proc_isrefcur_array">
  <cfprocparam type="out" cfsqltype="cf_sql_refcursor" variable="states">
</cfstoredproc>
<cfdump var="#states#">
Could it be you are using incorrect SYNTAX?
 
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!


PS: This:

TYPE refcArray IS REF CURSOR RETURN LU_State%ROWTYPE ;

Maybe does not match this, if all the columns are not selected:

SELECT StateID, State_Desc, State_AB ...

Author

Commented:
yes, I was thinking that as well...


maybe just a select * from LU_States?

What do you think?

Thx

Author

Commented:
OK..tried that and received the same error


Yes, try select *, if not, just remove the "RETURNING' from the type declaration.
 

Author

Commented:
can you show me what you mean?  thx

Author

Commented:
Turns out my CF Deeveloper wasn't pointing to the right server...thx
This:
 

CREATE OR REPLACE PACKAGE pack_isrefcur_array
AS
   TYPE refcarray IS REF CURSOR;
   PROCEDURE proc_isrefcur_array (outlu_state OUT refcarray);
END;
/

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial