Hi All,

I need help on the Stored Procedure badly. I tried to conduct research on this
issue but did not get much luck. I am sure I am not the only one who ran into
this problem and found a solution which can be shared.
Here is the issue: I am calling a DB2 stored procedure and I am getting this
database error:

queryError: The Specified library "SchemaName.ProcedureName" could not be
loaded.
NativeErrorCode: -10013
SQLState: HY000

I have everything setup and the datasource connection to the procedure is
checked. Here is my procedure call:

<cfset Variables.returnVal="" />
<cftry>
<cfstoredproc procedure="SchemaName.ProcedureName"
dataSource="DatasourceName" debug="Yes">
<cfprocparam type="InOut" cfsqltype="cf_sql_numeric" variable="Param1"
value="#value1#" />
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="Param2"
value="#value2#">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="Param3"
value="#value3#" />
<cfprocparam type="InOut" cfsqltype="cf_sql_numeric" variable="Param4"
value="#value4#" />
<cfprocresult name="returnVal" />
</cfstoredproc>
<cfcatch type="database">
queryError: <cfdump var="#cfcatch.queryError#"><br />
NativeErrorCode: <cfdump var="#cfcatch.NativeErrorCode#"><br />
SQLState: <cfdump var="#cfcatch.SQLState#"><br />
Message: <cfdump var="#cfcatch.message#"><br />
Sql: <cfdump var="#cfcatch.Sql#">
</cfcatch>
</cftry>

Thanks in advance for any help or ideas you can share...it is greatly
appreciated!