Thanks, but that didn't work. We're using DB2, Solaris 8, and Apache 2.13.
----- Original Message ----- From: "<"Everett>,Al"" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 2:17 PM Subject: RE: CFStoredProc > I've found that cfcprocresult should be last. (Oracle 8i/9i). Try that. > > > -----Original Message----- > > From: Nuovo [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, February 11, 2003 3:13 PM > > To: CF-Talk > > Subject: CFStoredProc > > > > > > Ok, gang, > > > > The following stored proc call works beautifully: > > > > <cfstoredproc procedure="test" datasource="#ds#"> > > <cfprocresult name="getAdID"> > > </cfstoredproc> > > > > It inserts a record into our test table and returns the ADID > > (INTEGER, autonumber) and DESC (CHAR, defaults to "TEST") fields. > > > > Then I try to pass the proc a value for DESC as follows: > > > > <cfstoredproc procedure="test" datasource="#ds#" debug="Yes"> > > <cfprocresult name="getAdID"> > > <cfprocparam dbvarname="DESC" value="Ryan" > > cfsqltype="CF_SQL_CHAR" type="In"> > > </cfstoredproc> > > > > And I get the following error: > > > > Error Diagnostic Information > > DB2 Error Code = -10013 > > > > [IBM][CLI Driver][DB2/SUN] SQL10013N The specified > > library "/export/home/testingUser/sqllib/function/test" could > > not be loaded. > > > > > > > > SQL = "test" > > > > Data Source = "TESTING" > > > > > > The error occurred while processing an element with a > > general identifier of (CFSTOREDPROC), occupying document > > position (15:1) to (15:61). > > > > > > Date/Time: Tue Feb 11 13:56:01 2003 > > Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT > > 5.0; T312461; .NET CLR 1.0.3705) > > Remote Address: > > > > > > > > > > I'm stumped, any thoughts? > > > > Thanks, > > > > Ryan > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
