Glen_D
asked on
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
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 ;
/
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 ;
/
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
ASKER
Thx...here's the CF code:
<cfstoredproc datasource="ericao" procedure="PACK_ISREFCUR_A RRAY.proc_ isrefcur_a rray">
<cfprocparam type="out" cfsqltype="cf_sql_refcurso r" variable="states">
</cfstoredproc>
<cfdump var="#states#">
<cfstoredproc datasource="ericao" procedure="PACK_ISREFCUR_A
<cfprocparam type="out" cfsqltype="cf_sql_refcurso
</cfstoredproc>
<cfdump var="#states#">
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes, I was thinking that as well...
maybe just a select * from LU_States?
What do you think?
Thx
maybe just a select * from LU_States?
What do you think?
Thx
ASKER
OK..tried that and received the same error
might try using
CF_SQL_CLOB instead of cf_sql_refcursor
https://www.experts-exchange.com/questions/20572816/CFStored-procedure-CFProcParam.html
CF_SQL_CLOB instead of cf_sql_refcursor
https://www.experts-exchange.com/questions/20572816/CFStored-procedure-CFProcParam.html
Yes, try select *, if not, just remove the "RETURNING' from the type declaration.
ASKER
can you show me what you mean? thx
ASKER
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;
/