An Oracle stored procedure that puts more than 255 bytes into an OUT
parameter throws an error
Oracle Error Code = 6502
ORA-06502: PL/SQL: numeric or value error ORA-06512: at
"SBRAKES.RETURNPARAMLENTESTER", line 9 ORA-06512: at line 1
in CF (CF 4.01, Oracle 8.0.4), using either csqltype="cf_sql_longvarchar" or
cfsqltype="cf_sql_varchar". Does anyone know of a workaround or fix? Can
anyone confirm that 4.5 solves this problem?
Test case:
create or replace PROCEDURE ReturnParamLenTester (p_outvar OUT varchar2)
IS
v_datachunk varchar2(50);
BEGIN
v_datachunk := 'blah blah blah blah blah blah blah blah blah
blah ';
p_outvar := v_datachunk || v_datachunk || v_datachunk ||
v_datachunk || v_datachunk || v_datachunk;
END ReturnParamLenTester;
<cfstoredproc datasource="dsn"
procedure="ReturnParamLenTester"
returncode="no">
<cfprocparam dbvarname="p_outvar"
cfsqltype="cf_sql_longvarchar"
type="out"
variable="variables.result">
</cfstoredproc>
<Cfoutput>#variables.result#<BR></cfoutput>
-------------------------------
Martin Herbener
[EMAIL PROTECTED]
Kentucky Department of Education
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
