dbms_lob is used to manipulate lobs
Procedures/Functions
append
procedure append (
dest_lob in out blob ,
src_lob in blob
);
procedure append (
dest_lob in out clob ,
src_lob in clob
);
close
procedure close (
lob_loc in out blob
);
procedure close (
lob_loc in out clob
);
procedure close (
file_loc file binary lob
);
compare
function compare returns number(38)
(
lob_1 in blob ,
lob_2 in blob ,
amount in number(38) default,
offset_1 in number(38) default,
offset_2 in number(38) default
);
function compare returns number(38)
(
lob_1 in clob ,
lob_2 in clob ,
amount in number(38) default,
offset_1 in number(38) default,
offset_2 in number(38) default
);
function compare returns number(38)
(
file_1 file binary lob,
file_2 file binary lob,
amount in number(38) ,
offset_1 in number(38) default,
offset_2 in number(38) default
);
converttoblob
procedure converttoblob (
dest_lob in out blob ,
src_clob in clob ,
amount in number(38) ,
dest_offset in out number(38) ,
src_offset in out number(38) ,
blob_csid in number ,
lang_context in out number(38) ,
warning out number(38)
);
converttoclob
procedure converttoclob (
dest_lob in out clob ,
src_blob in blob ,
amount in number(38) ,
dest_offset in out number(38) ,
src_offset in out number(38) ,
blob_csid in number ,
lang_context in out number(38) ,
warning out number(38)
);
copy
procedure copy (
dest_lob in out blob ,
src_lob in blob ,
amount in number(38) ,
dest_offset in number(38) default,
src_offset in number(38) default
);
procedure copy (
dest_lob in out clob ,
src_lob in clob ,
amount in number(38) ,
dest_offset in number(38) default,
src_offset in number(38) default
);
createtemporary
procedure createtemporary (
lob_loc in out blob ,
cache in boolean ,
dur in binary_integer default
);
procedure createtemporary (
lob_loc in out clob ,
cache in boolean ,
dur in binary_integer default
);
erase
procedure erase (
lob_loc in out blob ,
amount in out number(38) ,
offset in number(38) default
);
procedure erase (
lob_loc in out clob ,
amount in out number(38) ,
offset in number(38) default
);
fileclose
procedure fileclose (
file_loc file binary lob
);
filecloseall
procedure filecloseall (
);
fileexists
function fileexists returns number(38)
(
file_loc file binary lob
);
filegetname
procedure filegetname (
file_loc file binary lob,
dir_alias out varchar2 ,
filename out varchar2
);
fileisopen
function fileisopen returns number(38)
(
file_loc file binary lob
);
fileopen
procedure fileopen (
file_loc file binary lob,
open_mode in binary_integer default
);
freetemporary
procedure freetemporary (
lob_loc in out blob
);
procedure freetemporary (
lob_loc in out clob
);
getchunksize
function getchunksize returns number(38)
(
lob_loc in blob
);
function getchunksize returns number(38)
(
lob_loc in clob
);
getlength
function getlength returns number(38)
(
lob_loc in blob
);
function getlength returns number(38)
(
lob_loc in clob
);
function getlength returns number(38)
(
file_loc file binary lob
);
get_storage_limit
function get_storage_limit returns number(38)
(
lob_loc in clob
);
function get_storage_limit returns number(38)
(
lob_loc in blob
);
instr
function instr returns number(38)
(
lob_loc in blob ,
pattern in raw ,
offset in number(38) default,
nth in number(38) default
);
function instr returns number(38)
(
lob_loc in clob ,
pattern in varchar2 ,
offset in number(38) default,
nth in number(38) default
);
function instr returns number(38)
(
file_loc file binary lob,
pattern in raw ,
offset in number(38) default,
nth in number(38) default
);
isopen
function isopen returns number(38)
(
lob_loc in blob
);
function isopen returns number(38)
(
lob_loc in clob
);
function isopen returns number(38)
(
file_loc file binary lob
);
istemporary
function istemporary returns number(38)
(
lob_loc in blob
);
function istemporary returns number(38)
(
lob_loc in clob
);
loadblobfromfile
procedure loadblobfromfile (
dest_lob in out blob ,
src_bfile file binary lob,
amount in number(38) ,
dest_offset in out number(38) ,
src_offset in out number(38)
);
loadclobfromfile
procedure loadclobfromfile (
dest_lob in out clob ,
src_bfile file binary lob,
amount in number(38) ,
dest_offset in out number(38) ,
src_offset in out number(38) ,
bfile_csid in number ,
lang_context in out number(38) ,
warning out number(38)
);
loadfromfile
procedure loadfromfile (
dest_lob in out blob ,
src_lob file binary lob,
amount in number(38) ,
dest_offset in number(38) default,
src_offset in number(38) default
);
procedure loadfromfile (
dest_lob in out clob ,
src_lob file binary lob,
amount in number(38) ,
dest_offset in number(38) default,
src_offset in number(38) default
);
open
procedure open (
lob_loc in out blob ,
open_mode in binary_integer
);
procedure open (
lob_loc in out clob ,
open_mode in binary_integer
);
procedure open (
file_loc file binary lob,
open_mode in binary_integer default
);
read
procedure read (
lob_loc in blob ,
amount in out number(38) ,
offset in number(38) ,
buffer out raw
);
procedure read (
lob_loc in clob ,
amount in out number(38) ,
offset in number(38) ,
buffer out varchar2
);
procedure read (
file_loc file binary lob,
amount in out number(38) ,
offset in number(38) ,
buffer out raw
);
substr
function substr returns raw
(
lob_loc in blob ,
amount in number(38) default,
offset in number(38) default
);
function substr returns varchar2
(
lob_loc in clob ,
amount in number(38) default,
offset in number(38) default
);
function substr returns raw
(
file_loc file binary lob,
amount in number(38) default,
offset in number(38) default
);
trim
procedure trim (
lob_loc in out blob ,
newlen in number(38)
);
procedure trim (
lob_loc in out clob ,
newlen in number(38)
);
write
procedure write (
lob_loc in out blob ,
amount in number(38) ,
offset in number(38) ,
buffer in raw
);
procedure write (
lob_loc in out clob ,
amount in number(38) ,
offset in number(38) ,
buffer in varchar2
);
writeappend
procedure writeappend (
lob_loc in out blob ,
amount in number(38) ,
buffer in raw
);
procedure writeappend (
lob_loc in out clob ,
amount in number(38) ,
buffer in varchar2
);
|