Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.0 |  CUBRID 8.4.1 | 



The cubrid_lob_get function executes SQL statement and returns the value of every BLOB/CLOB type in resource array. Be sure that the SQL should have only one column and the type must be BLOB/CLOB.

Remember to use cubrid_lob_close() to release the BLOB or CLOB if you don't need it any more.


array cubrid_lob_get (resource $conn_identifier, string $SQL)

  • conn_identifier : Connection identifier
  • SQL : SQL statement to be executed.
Return Value
  • Success : An array of LOB resources
  • Failure : FALSE


$lobs = cubrid_lob_get($con, "SELECT doc_content FROM doc WHERE doc_id=5");

cubrid_lob_export($conn, $lobs[0], "doc_5.txt");



See Also