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

htp [Oracle]

Procedures/Functions

adddefaulthtmlhdr

procedure adddefaulthtmlhdr (
 baddhtmlhdr                        in                  boolean        
);

address

procedure address (
 cvalue                             in                 varchar2        ,
 cnowrap                            in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

anchor

procedure anchor (
 curl                               in                 varchar2        ,
 ctext                              in                 varchar2        ,
 cname                              in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

anchor2

procedure anchor2 (
 curl                               in                 varchar2        ,
 ctext                              in                 varchar2        ,
 cname                              in                 varchar2 default,
 ctarget                            in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

appletclose

procedure appletclose (
);

appletopen

procedure appletopen (
 ccode                              in                 varchar2        ,
 cwidth                             in               number(38)        ,
 cheight                            in               number(38)        ,
 cattributes                        in                 varchar2 default
);

area

procedure area (
 ccoords                            in                 varchar2        ,
 cshape                             in                 varchar2 default,
 chref                              in                 varchar2 default,
 cnohref                            in                 varchar2 default,
 ctarget                            in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

base

procedure base (
 ctarget                            in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

basefont

procedure basefont (
 nsize                              in               number(38)        
);

bgsound

procedure bgsound (
 csrc                               in                 varchar2        ,
 cloop                              in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

big

procedure big (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

blockquoteclose

procedure blockquoteclose (
);

blockquoteopen

procedure blockquoteopen (
 cnowrap                            in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

bodyclose

procedure bodyclose (
);

bodyopen

procedure bodyopen (
 cbackground                        in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

bold

procedure bold (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

br

procedure br (
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

center

procedure center (
 ctext                              in                 varchar2        
);

centerclose

procedure centerclose (
);

centeropen

procedure centeropen (
);

cite

procedure cite (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

code

procedure code (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

comment

procedure comment (
 ctext                              in                 varchar2        
);

dfn

procedure dfn (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

dirlistclose

procedure dirlistclose (
);

dirlistopen

procedure dirlistopen (
);

div

procedure div (
 calign                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

dlistclose

procedure dlistclose (
);

dlistdef

procedure dlistdef (
 ctext                              in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

dlistopen

procedure dlistopen (
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

dlistterm

procedure dlistterm (
 ctext                              in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

download_file

procedure download_file (
 sfilename                          in                 varchar2        ,
 bcompress                          in                  boolean default
);

em

procedure em (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

emphasis

procedure emphasis (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

escape_sc

procedure escape_sc (
 ctext                              in                 varchar2        
);

flush

procedure flush (
);

flush_charset_convert

procedure flush_charset_convert (
 charset                            in                 varchar2        
);

fontclose

procedure fontclose (
);

fontopen

procedure fontopen (
 ccolor                             in                 varchar2 default,
 cface                              in                 varchar2 default,
 csize                              in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formcheckbox

procedure formcheckbox (
 cname                              in                 varchar2        ,
 cvalue                             in                 varchar2 default,
 cchecked                           in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formclose

procedure formclose (
);

formfile

procedure formfile (
 cname                              in                 varchar2        ,
 caccept                            in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formhidden

procedure formhidden (
 cname                              in                 varchar2        ,
 cvalue                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formimage

procedure formimage (
 cname                              in                 varchar2        ,
 csrc                               in                 varchar2        ,
 calign                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formopen

procedure formopen (
 curl                               in                 varchar2        ,
 cmethod                            in                 varchar2 default,
 ctarget                            in                 varchar2 default,
 cenctype                           in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formpassword

procedure formpassword (
 cname                              in                 varchar2        ,
 csize                              in                 varchar2 default,
 cmaxlength                         in                 varchar2 default,
 cvalue                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formradio

procedure formradio (
 cname                              in                 varchar2        ,
 cvalue                             in                 varchar2        ,
 cchecked                           in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formreset

procedure formreset (
 cvalue                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formselectclose

procedure formselectclose (
);

formselectopen

procedure formselectopen (
 cname                              in                 varchar2        ,
 cprompt                            in                 varchar2 default,
 nsize                              in               number(38) default,
 cattributes                        in                 varchar2 default
);

formselectoption

procedure formselectoption (
 cvalue                             in                 varchar2        ,
 cselected                          in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formsubmit

procedure formsubmit (
 cname                              in                 varchar2 default,
 cvalue                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formtext

procedure formtext (
 cname                              in                 varchar2        ,
 csize                              in                 varchar2 default,
 cmaxlength                         in                 varchar2 default,
 cvalue                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formtextarea

procedure formtextarea (
 cname                              in                 varchar2        ,
 nrows                              in               number(38)        ,
 ncolumns                           in               number(38)        ,
 calign                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formtextarea2

procedure formtextarea2 (
 cname                              in                 varchar2        ,
 nrows                              in               number(38)        ,
 ncolumns                           in               number(38)        ,
 calign                             in                 varchar2 default,
 cwrap                              in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formtextareaclose

procedure formtextareaclose (
);

formtextareaopen

procedure formtextareaopen (
 cname                              in                 varchar2        ,
 nrows                              in               number(38)        ,
 ncolumns                           in               number(38)        ,
 calign                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

formtextareaopen2

procedure formtextareaopen2 (
 cname                              in                 varchar2        ,
 nrows                              in               number(38)        ,
 ncolumns                           in               number(38)        ,
 calign                             in                 varchar2 default,
 cwrap                              in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

frame

procedure frame (
 csrc                               in                 varchar2        ,
 cname                              in                 varchar2 default,
 cmarginwidth                       in                 varchar2 default,
 cmarginheight                      in                 varchar2 default,
 cscrolling                         in                 varchar2 default,
 cnoresize                          in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

framesetclose

procedure framesetclose (
);

framesetopen

procedure framesetopen (
 crows                              in                 varchar2 default,
 ccols                              in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

get_download_files_list

procedure get_download_files_list (
 sfileslist                        out                 varchar2        ,
 ncompress                         out           binary_integer        
);

get_line

function get_line returns varchar2 (
 irows                             out               number(38)        
);

get_page

procedure get_page (
 thepage                            of                    table varchar2,
 irows                          in out               number(38)        
);

get_page_charset_convert

procedure get_page_charset_convert (
 thepage                            of                    table varchar2,
 irows                          in out               number(38)        ,
 charset                            in                 varchar2        
);

get_page_raw

procedure get_page_raw (
 thepage                            of                    table     raw,
 irows                          in out               number(38)        
);

headclose

procedure headclose (
);

procedure header (
 nsize                              in               number(38)        ,
 cheader                            in                 varchar2        ,
 calign                             in                 varchar2 default,
 cnowrap                            in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

headopen

procedure headopen (
);

hr

procedure hr (
 cclear                             in                 varchar2 default,
 csrc                               in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

htitle

procedure htitle (
 ctitle                             in                 varchar2        ,
 nsize                              in               number(38) default,
 calign                             in                 varchar2 default,
 cnowrap                            in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

htmlclose

procedure htmlclose (
);

htmlopen

procedure htmlopen (
);

img

procedure img (
 curl                               in                 varchar2        ,
 calign                             in                 varchar2 default,
 calt                               in                 varchar2 default,
 cismap                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

img2

procedure img2 (
 curl                               in                 varchar2        ,
 calign                             in                 varchar2 default,
 calt                               in                 varchar2 default,
 cismap                             in                 varchar2 default,
 cusemap                            in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

init

procedure init (
);

isindex

procedure isindex (
 cprompt                            in                 varchar2 default,
 curl                               in                 varchar2 default
);

italic

procedure italic (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

kbd

procedure kbd (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

keyboard

procedure keyboard (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

line

procedure line (
 cclear                             in                 varchar2 default,
 csrc                               in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

linkrel

procedure linkrel (
 crel                               in                 varchar2        ,
 curl                               in                 varchar2        ,
 ctitle                             in                 varchar2 default
);

linkrev

procedure linkrev (
 crev                               in                 varchar2        ,
 curl                               in                 varchar2        ,
 ctitle                             in                 varchar2 default
);

listheader

procedure listheader (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

listingclose

procedure listingclose (
);

listingopen

procedure listingopen (
);

listitem

procedure listitem (
 ctext                              in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cdingbat                           in                 varchar2 default,
 csrc                               in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

mailto

procedure mailto (
 caddress                           in                 varchar2        ,
 ctext                              in                 varchar2        ,
 cname                              in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

mapclose

procedure mapclose (
);

mapopen

procedure mapopen (
 cname                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

procedure menulistclose (
);

procedure menulistopen (
);

meta

procedure meta (
 chttp_equiv                        in                 varchar2        ,
 cname                              in                 varchar2        ,
 ccontent                           in                 varchar2        
);

nextid

procedure nextid (
 cidentifier                        in                 varchar2        
);

nl

procedure nl (
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

nobr

procedure nobr (
 ctext                              in                 varchar2        
);

noframesclose

procedure noframesclose (
);

noframesopen

procedure noframesopen (
);

olistclose

procedure olistclose (
);

olistopen

procedure olistopen (
 cclear                             in                 varchar2 default,
 cwrap                              in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

p

procedure p (
 cbuf                               in                 varchar2 default
);

procedure p (
 dbuf                               in                     date        
);

procedure p (
 nbuf                               in                   number        
);

para

procedure para (
);

paragraph

procedure paragraph (
 calign                             in                 varchar2 default,
 cnowrap                            in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

param

procedure param (
 cname                              in                 varchar2        ,
 cvalue                             in                 varchar2        
);

plaintext

procedure plaintext (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

preclose

procedure preclose (
);

preopen

procedure preopen (
 cclear                             in                 varchar2 default,
 cwidth                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

print

procedure print (
 cbuf                               in                 varchar2 default
);

procedure print (
 dbuf                               in                     date        
);

procedure print (
 nbuf                               in                   number        
);

prints

procedure prints (
 ctext                              in                 varchar2        
);

procedure print_header (
 cbuf                               in                 varchar2        ,
 nline                              in                   number        
);

prn

procedure prn (
 cbuf                               in                 varchar2 default
);

procedure prn (
 dbuf                               in                     date        
);

procedure prn (
 nbuf                               in                   number        
);

ps

procedure ps (
 ctext                              in                 varchar2        
);

putraw

procedure putraw (
 bbuf                               in                      raw        ,
 buflen                             in           binary_integer default
);

s

procedure s (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

sample

procedure sample (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

script

procedure script (
 cscript                            in                 varchar2        ,
 clanguage                          in                 varchar2 default
);

sethttpcharset

procedure sethttpcharset (
 iana_charset                       in                 varchar2        ,
 ora_charset                        in                 varchar2 default
);

set_transfer_mode

procedure set_transfer_mode (
 tmode                              in                 varchar2        
);

showpage

procedure showpage (
);

small

procedure small (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

strike

procedure strike (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

strong

procedure strong (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

style

procedure style (
 cstyle                             in                 varchar2        
);

sub

procedure sub (
 ctext                              in                 varchar2        ,
 calign                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

sup

procedure sup (
 ctext                              in                 varchar2        ,
 calign                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

tablecaption

procedure tablecaption (
 ccaption                           in                 varchar2        ,
 calign                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

tableclose

procedure tableclose (
);

tabledata

procedure tabledata (
 cvalue                             in                 varchar2 default,
 calign                             in                 varchar2 default,
 cdp                                in                 varchar2 default,
 cnowrap                            in                 varchar2 default,
 crowspan                           in                 varchar2 default,
 ccolspan                           in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

tableheader

procedure tableheader (
 cvalue                             in                 varchar2 default,
 calign                             in                 varchar2 default,
 cdp                                in                 varchar2 default,
 cnowrap                            in                 varchar2 default,
 crowspan                           in                 varchar2 default,
 ccolspan                           in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

tableopen

procedure tableopen (
 cborder                            in                 varchar2 default,
 calign                             in                 varchar2 default,
 cnowrap                            in                 varchar2 default,
 cclear                             in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

tablerowclose

procedure tablerowclose (
);

tablerowopen

procedure tablerowopen (
 calign                             in                 varchar2 default,
 cvalign                            in                 varchar2 default,
 cdp                                in                 varchar2 default,
 cnowrap                            in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

teletype

procedure teletype (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

title

procedure title (
 ctitle                             in                 varchar2        
);

ulistclose

procedure ulistclose (
);

ulistopen

procedure ulistopen (
 cclear                             in                 varchar2 default,
 cwrap                              in                 varchar2 default,
 cdingbat                           in                 varchar2 default,
 csrc                               in                 varchar2 default,
 cattributes                        in                 varchar2 default
);

underline

procedure underline (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

variable

procedure variable (
 ctext                              in                 varchar2        ,
 cattributes                        in                 varchar2 default
);

wbr

procedure wbr (
);