CUBRID_LOB2_IMPORT(3) 1 CUBRID_LOB2_IMPORT(3)cubrid_lob2_import - Import BLOB/CLOB data from a file.
SYNOPSIS
bool cubrid_lob2_import (resource $lob_identifier, string $file_name)
DESCRIPTION
The cubrid_lob2_import(3) function is used to save the contents of BLOB/CLOB data from a file. To use this function, you must use
cubrid_lob2_new(3) or fetch a lob object from CUBRID database first. If the file already exists, the operation will fail. This function
will not influence the cursor position of the lob object. It operates the entire lob object.
PARAMETERS
o $lob_identifier
-Lob identifier as a result of cubrid_lob2_new(3) or get from the result set.
o $filename
-File name you want to import BLOB/CLOB data. It also supports the path of the file.
RETURN VALUES
TRUE if the process is successful and FALSE for failure.
EXAMPLES
Example #1
cubrid_lob2_export(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");
cubrid_execute($conn,"DROP TABLE if exists test_lob");
cubrid_execute($conn,"CREATE TABLE test_lob (id INT, contents CLOB)");
$req = cubrid_prepare($conn, "INSERT INTO test_lob VALUES (?, ?)");
cubrid_bind($req, 1, 1);
$lob = cubrid_lob2_new($conn, "clob");
cubrid_lob2_import($lob, "doc_1.txt");
cubrid_lob2_bind($req, 2, $lob, 'CLOB'); // or cubrid_lob2_bind($req, 2, $lob);
cubrid_execute($req);
cubrid_lob2_close($lob);
cubrid_disconnect($conn);
?>
SEE ALSO cubrid_lob2_new(3), cubrid_lob2_close(3), cubrid_lob2_export(3), cubrid_lob2_bind(3).
PHP Documentation Group CUBRID_LOB2_IMPORT(3)
Check Out this Related Man Page
CUBRID_LOB2_EXPORT(3) 1 CUBRID_LOB2_EXPORT(3)cubrid_lob2_export - Export the lob object to a file.SYNOPSIS
bool cubrid_lob2_export (resource $lob_identifier, string $file_name)
DESCRIPTION
The cubrid_lob2_export(3) function is used to save the contents of BLOB/CLOB data to a file. To use this function, you must use
cubrid_lob2_new(3) or fetch a lob object from CUBRID database first. If the file already exists, the operation will fail. This function
will not influence the cursor position of the lob object. It operates the entire lob object.
PARAMETERS
o $lob_identifier
-Lob identifier as a result of cubrid_lob2_new(3) or get from the result set.
o $filename
-File name you want to store BLOB/CLOB data. It also supports the path of the file.
RETURN VALUES
TRUE if the process is successful and FALSE for failure.
EXAMPLES
Example #1
cubrid_lob2_export(3) example
<?php
// Table: test_lob (id INT, contents CLOB)
$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')");
$req = cubrid_prepare($conn, "select * from doc");
cubrid_execute($req);
cubrid_move_cursor($req, 1, CUBRID_CURSOR_FIRST);
$row = cubrid_fetch($req, CUBRID_NUM | CUBRID_LOB);
cubrid_lob2_export($row[1], "doc_3.txt");
cubrid_lob2_close($row[1]);
cubrid_disconnect($conn);
?>
SEE ALSO cubrid_lob2_new(3), cubrid_lob2_close(3), cubrid_lob2_import(3), cubrid_lob2_bind(3).
PHP Documentation Group CUBRID_LOB2_EXPORT(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
I have a log file stored in unix file server i need to prepare the clob object of that and store in Oracle Database.
Please suggest me or give me some examples
Thanks
Raj (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 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)
I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)