A PL/SQL package for selecting CLOB columns and BLOB columns across a DBLink.

It contains two small functions:

• GET_CLOB(....): Selects a CLOB over a DBLink.
  
• GET_BLOB(....): Selects a BLOB over a DBLink.
  

LOB_OVER_DBLINK requires NO SETUP on the remote database.

Example usage:

select lob_over_dblink.get_clob('some_dblink', 'some_clob_column', rowid)
     , lob_over_dblink.get_blob('some_dblink', 'some_blob_column', rowid)
  from some_table@some_dblink;

Installing and uninstalling:

Download and extract the zip file.
Using SQL*Plus:

• To Install: SQL>@install
  
• To uninstall: SQL>@uninstall
  

Author:

Laurence Prescott
howdprescott@hotmail.com
https://github.com/HowdPrescott/Lob_Over_DBLink

    :smiling_imp: