oracle stored procedure calling

[Raju_bhupesh]

I have two procedures test1 and test2. Resultset is returned by test2.
My coldfusion code calls test1.


PROCEDURE test1 (in_eid IN NUMBER, out_rs1 OUTREF_CURSOR)
IS
BEGIN

if eid =5 then
test2 (out_rs1 OUTREF_CURSOR);
end if;
END test1;


PROCEDURE test2 (out_rs1 OUTREF_CURSOR)
IS
BEGIN

OPEN out_rs1
FOR
SELECT *
FROM table1
END test2;


<CFSTOREDPROC PROCEDURE="test1" DATASOURCE="ps-db">
<cfproc param type="in" dbvarname="in_eid" value="5">
<CFPROCRESULT NAME="RS">
</CFSTOREDPROC>


Error I am getting "Unsupported data conversion". When I call single procedure
independently it's works fine.
Please suggest if coldfusion support this type of procedure calling.

[paross1]

Not sure if this is your problem, but are your procedures in a PL/SQL package?
If you wish to return result sets to ColdFusion using reference cursors, your
procedures must be in a package because you must declare the reference cursor
type globally in the package spec.

Phil

[Raju_bhupesh]

Wow it's works ....
Thanks a lot Phil