ID: 17063 Updated by: [EMAIL PROTECTED] Reported By: sureshkb at orillion dot com -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-01-29 08:26:41] [EMAIL PROTECTED] Moving this to OCI8, which is where OCIPLogon() belongs. (this mess between the two Oracle extensions gotta end someday .... argh..) ------------------------------------------------------------------------ [2002-05-07 04:38:05] sureshkb at orillion dot com <?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 ------------------------------------------------------------------------ [2002-05-07 03:05:07] [EMAIL PROTECTED] 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 at orillion dot 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 at orillion dot 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
