Insert query in Oracle database using php and COM
| From: | Julian | Date: | Thu, 29 Mar 2001 15:45:04 +0000 |
| Subject: | Insert query in Oracle database using php and COM | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-6371@lists.php.net to get a copy of this message | ||
i did this :
$oConn = new COM("ADODB.Connection");
$oConn ->ConectionString =
<<<<<<<<string>>>>>>>> ;
the next command works fine:
$oConn->Execute( "insert into Paciente
(nid,nombre,Apell1,Apell2,Sexo,NHisto,FNac) values
(10042,'wfcwsfvwsvcsw','ewfrewfrew','dsfdsfsf','Hombre','121219',to_date('12
/1/1980','MM-DD-YYYY')) ");
but if i execute this one the php fails with an error of memory:
$oConn->Execute("insert into Peticion
(NID,NPet,NPac,Diagnostico,FPet,Medico,Servicio,FPetFin,nidPass,obsPet,obsIn
f,codSer,itt) values
(10060,'56',10040,3,to_date('29-03-2001','DD-MM-YYYY'),'Julian','urgencias
',to_date('12-1-2001','DD-MM-YYYY'),1,'oooo','ttt','urgencias
','vv')");
if i copy into a sql tool and execute it works fine!!!!.
Somebody knows why?
Regards