But here is what I tried:
---------------
<cfstoredproc procedure="IAWA_PKG.getIAWAPage"
datasource="InsideWood" debug="yes" returncode="yes">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="A" null="no">
<cfprocparam type="InOut" cfsqltype="CF_SQL_REFCURSOR" value="xxx">
<cfprocresult name="p_rs" resultset="1">
</cfstoredproc>
--------------------
Here is the Error I got back:
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]The specified SQL type is not supported
by this driver.
The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc:
line 25
23 : <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="A"
null="no">
24 : <cfprocparam type="InOut" cfsqltype="CF_SQL_REFCURSOR"
value="xxx">
25 : <cfprocresult name="p_rs" resultset="1">
26 : </cfstoredproc>
27 :
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
