CUBRID_LOB_SIZE(3) 1 CUBRID_LOB_SIZE(3)cubrid_lob_size - Get BLOB/CLOB data size
SYNOPSIS
string cubrid_lob_size (resource $lob_identifier)
DESCRIPTION cubrid_lob_size(3) is used to get BLOB/CLOB data size.
PARAMETERS
o $lob_identifier
-LOB identifier.
RETURN VALUES
A string representing LOB data size, when process is successful.
FALSE, when process is unsuccessful.
CHANGELOG
+--------+-----------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-----------------------------------------------+
| 8.4.0 | |
| | |
| | Change return value type from int to string. |
| | |
+--------+-----------------------------------------------+
EXAMPLES
Example #1
cubrid_lob_size(3) example
<?php
$lobs = cubrid_lob_get($con, "SELECT doc_content FROM doc WHERE doc_id=5");
echo "Doc size:".cubrid_lob_size($lobs[0]);
cubrid_lob_export($conn, $lobs[0], "doc_5.txt");
cubrid_lob_close($lobs);
?>
SEE ALSO cubrid_lob_get(3), cubrid_lob_close(3), cubrid_lob_export(3), cubrid_lob_send(3).
PHP Documentation Group CUBRID_LOB_SIZE(3)
Check Out this Related Man Page
CUBRID_LOB_CLOSE(3) 1 CUBRID_LOB_CLOSE(3)cubrid_lob_close - Close BLOB/CLOB data
SYNOPSIS
bool cubrid_lob_close (array $lob_identifier_array)
DESCRIPTION cubrid_lob_close(3) is used to close all BLOB/CLOB returned from cubrid_lob_get(3).
PARAMETERS
o $lob_identifier_array
-LOB identifier array return from cubrid_lob_get.
RETURN VALUES
TRUE, when process is successful.
FALSE, when process is unsuccessful.
EXAMPLES
Example #1
cubrid_lob_close(3) example
<?php
$conn = cubrid_connect ("localhost", 33000, "demodb", "dba");
cubrid_execute($conn,"DROP TABLE if exists doc");
cubrid_execute($conn,"CREATE TABLE doc (id INT, doc_content CLOB)");
cubrid_execute($conn,"INSERT INTO doc VALUES (5,'hello,cubrid')");
$lobs = cubrid_lob_get($conn, "SELECT doc_content FROM doc WHERE id=5");
echo "Doc size: ".cubrid_lob_size($lobs[0])." bytes";
cubrid_lob_export($conn, $lobs[0], "doc_5.txt");
cubrid_lob_close($lobs);
cubrid_disconnect($conn);
?>
SEE ALSO cubrid_lob_get(3), cubrid_lob_size(3), cubrid_lob_export(3), cubrid_lob_send(3).
PHP Documentation Group CUBRID_LOB_CLOSE(3)
Hi,
this may not be a right place to post my question. But still....
I have database table of which one field contains BLOB data. Actually the BLOB data is xml script.
Now How do I retrieve that xml script to xml file on unix(or windows). I will have to loop thru the records. There are... (0 Replies)
Hi All,
I have a big file (basically .log file) want to store in oracle database.
Please help me in preparing CLOB object in unix.
The log file is stored in some location on unix file server, prepare clob of that file and store in DB.
Any sample code or link
Thanks
Rajesh (1 Reply)
Hi All,
I want to insert xyz.log file in CLOB field of Oracle DB. The log file increases its size dynamically. When i am inserting the file into DB i have to check the size of the file, if its size is more than 32KB then insert upto that size into CLOB field of DB. Otherwise proceed normally.
... (1 Reply)
Hi All,
I want to store 32KB of file in Oracle DB into CLOB field. I am not able to insert more than 32KB of file into CLOB. So i want to put a limit on the file size. I am using k shell.
My file size will dynamically increase its size, i want to check the file size if it is more than 32KB... (1 Reply)
Hi,
Please guide me where i am doing wrong, i am getting
ORA-01756:quoted string not properly terminated when i am trying to insert file into CLOB cloumn of Oracle DB.
Please find below the code where log file variable is myLogFile. Please let me know where i am doing wrong.
... (0 Replies)