Action Requested: None Deadline: - OK to Forward: Yes Brian, Because of the error code, I'm betting you're calling an Oracle stored procedure from the CF template. It sounds like the parameter declaration restricts it to 200 characters. It's possible (in fact, it's preferred) to have that declaration reference the column in the target table, if the column definition changes, so with the PL/SQL stored procedure. If you're not actually calling an Oracle stored procedure from the CF template, then I'd start looking for an insert trigger for the table. The trigger may have a string that's declared to be too short for the data you're inserting. Anyway, I hope that helps. Chris -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian Bessemer Sent: Wednesday, February 28, 2001 9:44 AM To: '[EMAIL PROTECTED]' Subject: Oracle Error with Cold Fusion I've been working on an admin system lately with cold fusion 4.5 and oracle 8i When adding new content, I can enter anything up to 200 characters. As soon as I go over 200 characters, I get the following error message: ORA-06502: PL/SQL: numeric or value error: character string buffer too small The data is being inserted into a VARCHAR2(2048) column. Has anyone out there experienced this before? I don't think it's related to the cold fusion, but on the of chance it is, doeas anyone have any idea what's going on? brian bessemer specialist, web technologies 214.224.1164 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> imc2.com <http://www.imc2.com/> 7505 john carpenter frwy dallas, texas 75247 214.224.1000 fax/214.224.1100 ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
BEGIN:VCARD VERSION:2.1 N:Hardage;Christopher;M. FN:Christopher M. Hardage NICKNAME:Chris ORG:Wattage Monitor, Inc.;Information Technology TITLE:Senior Web Developer TEL;WORK;VOICE:(972) 669-0307 TEL;HOME;VOICE:(972) 644-0087 TEL;CELL;VOICE:(214) 926-6496 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;Dallas;3131 McKinney Avenue=0D=0ASuite L10;Dallas;Texas;75204;United States= of America LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Dallas=0D=0A3131 McKinney Avenue=0D=0ASuite L10=0D=0ADallas, Texas 75204=0D= =0AUnited States of America X-WAB-GENDER:2 URL: URL:http://www.wattagemonitor.com/ KEY;X509;ENCODING=BASE64: MIICpzCCAhCgAwIBAgIDAz/+MA0GCSqGSIb3DQEBBAUAMIGUMQswCQYDVQQGEwJaQTEVMBMG A1UECBMMV2VzdGVybiBDYXBlMRQwEgYDVQQHEwtEdXJiYW52aWxsZTEPMA0GA1UEChMGVGhh d3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwg RnJlZW1haWwgUlNBIDE5OTkuOS4xNjAeFw0wMDA5MTMxNDU3NDdaFw0wMTA5MTMxNDU3NDda MEcxHzAdBgNVBAMTFlRoYXd0ZSBGcmVlbWFpbCBNZW1iZXIxJDAiBgkqhkiG9w0BCQEWFWNo YXJkYWdlQHdtb25pdG9yLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAuTz5hKA0 S1eMd/3D48yGNDbszGw32e+nYoN/xoOKSnbOylI1n+l3EWwu+P7kpnmS1/6Hsdh7yK+v9PeB A0slrwr1P73WsuxIGtJQWCV3v/m8UByPZt0fvzq91bYsBSkss9dRQVSB8V2QF53siXNDiKPG FEgz0SWMKA9LAtj1zi8CAwEAAaNTMFEwIAYDVR0RBBkwF4EVY2hhcmRhZ2VAd21vbml0b3Iu Y29tMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUiKvxYINmVfTkWMdGHcBhvSPXw4wwDQYJ KoZIhvcNAQEEBQADgYEAWCEyLJVYVXbQMtxtDX2+9UHydOZaVENqGkAl7IWpD7EfjR9z7P0e H+4iCtXgMCdhmsV+9A984m8i91h/dymor1CHXRWzS8v+2WuocxQDA35yRRwE7G/fXu4eXEFX P7q09zf8QG3+ZKWun+bCJ7FBjgfdLerYnYcB9gPUIoHoxSs= EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20001101T163137Z END:VCARD
