|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2002-05-07 00:28 UTC] sureshkb at orillion dot com
Hi, I am trying to insert the long datatype into oracle8 database but it is throwing exception. bye, Suresh PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Oct 25 18:00:02 2025 UTC |
<?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