Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

cubrid_lob_close(3) [php 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)

Check Out this Related Man Page

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)
Man Page

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Creating CLOB object in unix

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)
Discussion started by: rajeshorpu
1 Replies

2. UNIX for Advanced & Expert Users

Unix commands Related to

Hi all, Does unix has any commands for creating BLOB and CLOB objects. Please forward me any sites or samples (2 Replies)
Discussion started by: rajeshorpu
2 Replies

3. Shell Programming and Scripting

Limit on a File size.

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)
Discussion started by: rajeshorpu
1 Replies

4. Shell Programming and Scripting

ORA-01756 Error while inserting a file in CLOB field

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)
Discussion started by: rajeshorpu
0 Replies

5. Shell Programming and Scripting

Script to parse a file faster

My example file is as given below: conn=1 uid=oracle conn=2 uid=db2 conn=3 uid=oracle conn=4 uid=hash conn=5 uid=skher conn=6 uid=oracle conn=7 uid=mpalkar conn=8 uid=anarke conn=1 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.10.5.6 to 10.18.6.5 conn=2 op=-1 msgId=-1 -... (7 Replies)
Discussion started by: sags007_99
7 Replies

6. Shell Programming and Scripting

Need help to replace a perl pattern matching

My example file is as given below: conn=1 uid=oracle conn=2 uid=db2 conn=3 uid=oracle conn=4 uid=hash conn=5 uid=skher conn=6 uid=oracle conn=7 uid=mpalkar conn=8 uid=anarke conn=9 uid=oracle conn=1 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.10.5.6 to 10.18.6.5 conn=2... (4 Replies)
Discussion started by: sags007_99
4 Replies

7. Shell Programming and Scripting

Help need with PERL multiple search pattern matching!

My example file is as given below: conn=1 uid=oracle conn=2 uid=db2 conn=3 uid=oracle conn=4 uid=hash conn=5 uid=skher conn=6 uid=oracle conn=7 uid=mpalkar conn=8 uid=anarke conn=9 uid=oracle conn=1 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.10.5.6 to 10.18.6.5 conn=2... (3 Replies)
Discussion started by: sags007_99
3 Replies

8. Programming

Mysql++

code: #include <mysql/mysql.h> #include <my_global.h> int main(int argc, char **argv) { MYSQL *conn; conn = mysql_init(NULL); mysql_real_connect(conn, "localhost", "zetcode", "passwd", "testdb", 0, NULL, 0); mysql_query(conn, "use vobd_db"); mysql_query(conn, "select *... (1 Reply)
Discussion started by: raj6
1 Replies