I have a php/mysql app that sends data to an oracle db. The cliient got this error. Can anyone see the problem with the string that is being sent?
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "terryM.MANAGER", line 358 ORA-06512: at line 1 in /usr/www/url/charlieHorse.techsolution.com/include/class.project.php on line 339
Couldn't Execute begin Manager.CreateProject ('119202','25505','Flyer - Marschal Overview','32','Charlie Group','Deliver To: print in-house; 120 color copies; deliver by 3/20 to: Attn: larry low 2682 thomas Drive, Suite 123 P.O. Box 1307 San berdino, CA 94000 Path To Text: Draft Due: 03/02/2009','Flyer',NULL,'23-FEB-09','02-MAR-09',NULL,NULL,'09-MAR-09',NULL,NULL,NULL,NULL,'mitchell Green',NULL,NULL,NULL,'print in-house; 120 color copies; deliver by 3/20 to: Attn: roger moore 2682 michell Drive, Suite 123 P.O. Box 1807 San bernadino, CA 94000 ',NULL,NULL,NULL,NULL,NULL,:var_out); end;