René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_lob

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        
);