Bug #17063 Updated: Can't able to insert long datatype into oracle8 database

ID: 17063 Updated by: sureshkb@orillion.com Reported By: sureshkb@orillion.com Status: Bogus Bug Type: Oracle related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: <?php include("TempStr.php"); function gendbins1($dbn,$tbn,$cols,$vals){ global $info; global $debug; $result; $info['db']['proto'] = "TCP"; $info['db']['ip'] = "192.168.1.133"; $info['db']['port'] = "1521"; $info['db']['sid'] = "ovdb"; $info['db']['user'] = "logdata"; $info['db']['pass'] = "logdata"; $info['db']['oraspecs']="(DESCRIPTION = (ADDRESS = (PROTOCOL = " . $info['db']['proto'] . ")(HOST = " . $info['db']['ip'] . ")(PORT = " . $info['db']['port'] . "))(CONNECT_DATA = (SID = " . $info['db']['sid'] . ")))"; $c1 = ociplogon($info[$dbn]['user'], $info[$dbn]['pass'], $info[$dbn]['oraspecs']); $q1 = "INSERT INTO $tbn $cols values :valdef"; echo"<P>Query toinsert user is - $q1"; $s1 = ociparse($c1, $q1); ocibindbyname($s1, ":valdef", &$vals); if($debug){$result = ociexecute($s1);} else {$result = @ociexecute($s1);}; ocicommit($c1); echo "The result from ins ==== $result"; }; $col=('FILTER'); $val="('$str')"; gendbins1('adm','XMLLONG',$col,$val); ?> here the code i am using and $str is in "TempStr.php" file and i am able to inserting the small strings(Aprox 2k) and i could not able to insert the big string. My table have only one column and datatype is "long". My apache server and database are not in same mechine. This is the information i am providing. Bye Suresh Previous Comments: ------------------------------------------------------------------------ [2002-05-07 03:05:07] derick@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". ------------------------------------------------------------------------ [2002-05-07 00:38:26] sureshkb@orillion.com Here small change i am not able to insert the long string i.e more than 50k but i can able in insert 1k string. Thanks, Suresh ------------------------------------------------------------------------ [2002-05-07 00:28:31] sureshkb@orillion.com Hi, I am trying to insert the long datatype into oracle8 database but it is throwing exception. bye, Suresh ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17063&edit=1