I want to retrieve data from my oracle db,my script is as follows:
//This is the table where the data stores
create table testlob
(id number(2),
description clob
)
//script
<?php
$conn = OCILogon("technet","technet","prcu");
if ($conn)
{
$stmt = OCIParse($conn,"select description from testlob");
$result=array();
OCIDefineByName($stmt,"DESCRIPTION",&$result[DESCRIPTION]);
OCIExecute($stmt);
while(OCIFetch($stmt))
{
if (is_object($result[DESCRIPTION])){
printf($result[DESCRIPTION]->load());
}else{
printf("failure");
}
}
OCIFreeStatement($stmt);
}
OCILogoff($conn);
?>
When I run it ,a warning appears before the data in that colomn as follows,and the content of that colomn is a part of the whole content:
Warning: OCILobRead: OCI_NEED_DATA in /home/nyber/lob/lob1.php3 on line 12
CREATE TABLE DULL ( DULL VARCHAR2(1) NULL ); CREATE TABLE ADMIN_SYSREF ( ID VARCHAR2(4) NOT NULL, ENGNAME VARCHAR2(20) NOT NULL, CHINAME VARCHAR2(20) NOT NULL, REFVALUES VARCHAR2(254) NOT NULL, NODENUMBER VARCHAR2(4) NOT NULL ); CREATE TABLE ADMIN_USER ( ADMINID VARCHAR2(16) NOT NULL, ADMINNAME VARCHAR2(16) NULL, PASSWORD VARCHAR2(30) NULL, TYPENAME NUMBER(4) NULL ); CREATE TABLE USER_USERINF ( USERID VARCHAR2(16) NOT NULL, PASSWORD VARCHAR2(18) .....
I NEED YOUR HELP VERY MUCH ,PLEASE GIVE ME YOUR SUGGEST!THANKS A LOT!
//This is the table where the data stores
create table testlob
(id number(2),
description clob
)
//script
<?php
$conn = OCILogon("technet","technet","prcu");
if ($conn)
{
$stmt = OCIParse($conn,"select description from testlob");
$result=array();
OCIDefineByName($stmt,"DESCRIPTION",&$result[DESCRIPTION]);
OCIExecute($stmt);
while(OCIFetch($stmt))
{
if (is_object($result[DESCRIPTION])){
printf($result[DESCRIPTION]->load());
}else{
printf("failure");
}
}
OCIFreeStatement($stmt);
}
OCILogoff($conn);
?>
When I run it ,a warning appears before the data in that colomn as follows,and the content of that colomn is a part of the whole content:
Warning: OCILobRead: OCI_NEED_DATA in /home/nyber/lob/lob1.php3 on line 12
CREATE TABLE DULL ( DULL VARCHAR2(1) NULL ); CREATE TABLE ADMIN_SYSREF ( ID VARCHAR2(4) NOT NULL, ENGNAME VARCHAR2(20) NOT NULL, CHINAME VARCHAR2(20) NOT NULL, REFVALUES VARCHAR2(254) NOT NULL, NODENUMBER VARCHAR2(4) NOT NULL ); CREATE TABLE ADMIN_USER ( ADMINID VARCHAR2(16) NOT NULL, ADMINNAME VARCHAR2(16) NULL, PASSWORD VARCHAR2(30) NULL, TYPENAME NUMBER(4) NULL ); CREATE TABLE USER_USERINF ( USERID VARCHAR2(16) NOT NULL, PASSWORD VARCHAR2(18) .....
I NEED YOUR HELP VERY MUCH ,PLEASE GIVE ME YOUR SUGGEST!THANKS A LOT!