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
