All:
I am not sure that my code is right for retriving a ref Cursor in oracle.
I am using MX6.1 and Oracle 9.1
from Oracle:
create or replace procedure testA as
type rs_type is ref cursor return spbldinf%rowtype;
rs_var rs_type;
begin
open rs_var for select * from spbldinf where spbldinf_code='38-066';
end testA;
calling stored procedure from Coldfusion:
<cfstoredproc DATASOURCE="#DSN#" procedure="testA" >
<cfprocresult name="rs_type">
</cfstoredproc>
<cfdump var="#rs_type#">
thanks
seng
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev'
in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported
by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
