ID: 17063
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Bogus
+Status: Open
Bug Type: Oracle related
Operating System: Windows 2000
PHP Version: 4.1.2
Previous Comments:
------------------------------------------------------------------------
[2002-05-07 04:38:05] [EMAIL PROTECTED]
<?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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
