<cfprocresult> has a maxrows attribute <cfprocresult name="smellyCheese" maxrows="20">
hope this helps, -chris.alvarado [application developer - 4 Guys Interactive] >From: Troy Simpson <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Oracle Stored Procedure and <cfstoredProc> >Date: Thu, 13 Dec 2001 14:22:34 -0500 > >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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists