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
