We are attempting to execute a stored procedure with this piece of code.
<cfstoredproc returncode="yes" datasource="purload"
procedure="co_error.check_records" debug="yes"> <cfprocparam type="in"
cfsqltype="cf_sql_decimal" value="2010"> </cfstoredproc>
As you can see, it is a pretty small <cfstoredproc...> block. Executing
it returns this error.
[Macromedia][Oracle JDBC Driver]Unhandled sql type
The error occurred in D:\playground\warren\PpurComponents.cfc: line 49
Called from D:\playground\warren\ppur_file_import.cfm: line 53
Called from D:\playground\warren\PpurComponents.cfc: line 49
Called from D:\playground\warren\ppur_file_import.cfm: line 53
Here is what I hope is the relevant portion of a 1400 line stored
procedure located in Oracle. We don't get to refactor the stored
procedure until phase two of this project.
PROCEDURE Check_records(p_year IN NUMBER)
AS
v_use_no NUMBER(8);
v_error_code BINARY_INTEGER := 0;
v_error_type VARCHAR2(20);
...
This project is to replace a 15 year old Perl program to used to call
this procedure with this code.
open(SQL_OUTPUT, "sqlplus -S ops\$xxxxx/yyyy...@dev11ge \...@check_errors
$year |")
That executed this SQL file.
* Run the error checking procedures
*/
SET pause off
SET verify off
SET TERMOUT ON
SET FEEDBACK OFF
SET document off
SET serveroutput ON size 1000000 format word_wrapped
WHENEVER SQLERROR EXIT 1 ROLLBACK
WHENEVER OSERROR EXIT 1 ROLLBACK
EXECUTE Co_error.Check_records(&1);
show errors
EXIT 0
Can anybody provide some insight on why this won't work form our CFML?
TIA
Ian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335684
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
