can you post the code between the cfstoredproc tags? dylan
----- Original Message ----- From: "Riaz Sulaimi" <[EMAIL PROTECTED]> To: "CF-Server" <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 3:06 AM Subject: CFPROCPARAM tag oracle error 6502 > Hiya all, > > I recently upgraded our Coldfusion server from 4.5.1 sp1 to 5.0, but > encounter a problem after testing: our application fails in 5.0 while it > was running fine under 4.5.1: > > The tag CFPROCPARAM - when you pass CF_SQL_CHAR parameters to ORACLE > stored > procedure, hits an oracle error : > > Oracle Error Code = 6502 > ORA-06502: PL/SQL: numeric or value error > > Although this can be solved by changing CF_SQL_CHAR to > CF_SQL_VARCHAR, we can't afford to do so as it will involve a change to > the whole application. > > Is there a workaround to this? > > Thanks in advance :) > > Riaz > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
