#17063 [Opn]: Can't able to insert long datatype into oracle8 database
| From: | maxim@php.net | Date: | Wed, 29 Jan 2003 14:26:42 +0000 |
| Subject: | #17063 [Opn]: Can't able to insert long datatype into oracle8 database | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-31581@lists.php.net to get a copy of this message | ||
ID: 17063
Updated by: maxim@php.net
Reported By: sureshkb@orillion.com
Status: Open
-Bug Type: Oracle related
+Bug Type: OCI8 related
Operating System: Windows 2000
PHP Version: 4.1.2
New Comment:
Moving this to OCI8, which is where OCIPLogon() belongs.
(this mess between the two Oracle extensions gotta end someday ....
argh..)
Previous Comments:
------------------------------------------------------------------------
[2002-05-07 04:38:05] sureshkb@orillion.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] 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