#17063 [Opn->Fbk]: Can't able to insert long datatype into oracle8 database
| From: | iliaa@php.net | Date: | Mon, 30 Jun 2003 02:33:31 +0000 |
| Subject: | #17063 [Opn->Fbk]: Can't able to insert long datatype into oracle8 database | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-42790@lists.php.net to get a copy of this message | ||
ID: 17063
Updated by: iliaa@php.net
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] maxim@php.net
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] 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 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