All,
Is it possible to pass a parameter into an Oracle Stored Procedure to
limit the record set that is returned but the procedure? If I remove
the "IN" Parameter from the Oracle Stored Procedure, it works fine. But
I do not want all the records. I just want a return a set of records.
I appears that it is not possible to supply additional values to
<CFstoredproc> when trying to retrieve a record set.
I have the <cfstoredproc> tag defined as follows:
<cfstoredproc
procedure="Portfolio.Get_Branch"
datasource="#Application.DSN#"
dbtype="#Application.DSNDBType#">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="p_ObjPK"
value="34" null="No">
<cfprocparam type="Out" cfsqltype="CF_SQL_REFCURSOR"
variable="p_Branch" null="Yes">
<cfprocresult name= rs>
</cfstoredproc>
Here is the definitions in my Oracle Package Header and Body:
***In the Header:***
Type Blank_CurType Is Ref Cursor;
Procedure Get_Branch
(
p_ObjPK in Number,
p_Branch out Blank_CurType
);
***In the Body:***
Procedure Get_Branch
(
p_ObjPK in Number,
p_Branch out Blank_CurType
)
Is
Begin
Open p_Branch For Select * from cobj;
-- I want to do this: Open p_Branch For Select * from cobj where
objpk = p_objpk;
End Get_Branch;
I hope that I have explained it well enough.
Thanks,
Troy
--
Troy Simpson | North Carolina State University
NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
It is better to be hated for what you are
than to be loved for what you are not.
-- Andre Gide
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
