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

dbms_sql

Procedures/Functions

bind_array

procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 n_tab                              of                    table  number
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 c_tab                              of                    table varchar2
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 d_tab                              of                    table    date
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 bl_tab                             of                    table    blob
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 cl_tab                             of                    table    clob
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 bf_tab                             of                    table  binary
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 n_tab                              of                    table  number,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 c_tab                              of                    table varchar2,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 d_tab                              of                    table    date,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 bl_tab                             of                    table    blob,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 cl_tab                             of                    table    clob,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 bf_tab                             of                    table  binary,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 ur_tab                             of                    table   rowid
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 ur_tab                             of                    table   rowid,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 tm_tab                             of                    table    time
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 tm_tab                             of                    table    time,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 tms_tab                            of                    table timestamp
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 tms_tab                            of                    table timestamp,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 ttz_tab                            of                    table    time
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 ttz_tab                            of                    table    time,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 tstz_tab                           of                    table timestamp
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 tstz_tab                           of                    table timestamp,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 tstz_tab                           of                    table timestamp
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 tstz_tab                           of                    table timestamp,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 iym_tab                            of                    table interval
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 iym_tab                            of                    table interval,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 ids_tab                            of                    table interval
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 ids_tab                            of                    table interval,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 bflt_tab                           of                    table binary_float
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 bflt_tab                           of                    table binary_float,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 bdbl_tab                           of                    table binary_double
);
procedure bind_array (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 bdbl_tab                           of                    table binary_double,
 index1                             in               number(38)        ,
 index2                             in               number(38)        
);

bind_variable

procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                   number        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                 varchar2        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                 varchar2        ,
 out_value_size                     in               number(38)        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                     date        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                     blob        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                     clob        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            file                   binary     lob
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                    rowid        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                     time        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                timestamp        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            with                     time    time
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            with                timestamp    time
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            with                timestamp   local
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            year                 interval      to
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             day                 interval      to
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in             binary_float        
);
procedure bind_variable (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in            binary_double        
);

bind_variable_char

procedure bind_variable_char (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                     char        
);
procedure bind_variable_char (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                     char        ,
 out_value_size                     in               number(38)        
);

bind_variable_raw

procedure bind_variable_raw (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                      raw        
);
procedure bind_variable_raw (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                      raw        ,
 out_value_size                     in               number(38)        
);

bind_variable_rowid

procedure bind_variable_rowid (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              in                    rowid        
);

close_cursor

procedure close_cursor (
 c                              in out               number(38)        
);

column_value

procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                   number        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                 varchar2        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                     date        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                     blob        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                     clob        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                            file                   binary     lob
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                   number        ,
 column_error                      out                   number        ,
 actual_length                     out               number(38)        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                 varchar2        ,
 column_error                      out                   number        ,
 actual_length                     out               number(38)        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                     date        ,
 column_error                      out                   number        ,
 actual_length                     out               number(38)        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 n_tab                              of                    table  number
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 c_tab                              of                    table varchar2
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 d_tab                              of                    table    date
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 bl_tab                             of                    table    blob
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 cl_tab                             of                    table    clob
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 bf_tab                             of                    table  binary
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                    rowid        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 ur_tab                             of                    table   rowid
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                     time        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 tm_tab                             of                    table    time
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                timestamp        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 tms_tab                            of                    table timestamp
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                            with                     time    time
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 ttz_tab                            of                    table    time
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                            with                timestamp    time
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 tstz_tab                           of                    table timestamp
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                            with                timestamp   local
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 tstz_tab                           of                    table timestamp
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                            year                 interval      to
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 iym_tab                            of                    table interval
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             day                 interval      to
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 ids_tab                            of                    table interval
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out             binary_float        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 bflt_tab                           of                    table binary_float
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out            binary_double        
);
procedure column_value (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 bdbl_tab                           of                    table binary_double
);

column_value_char

procedure column_value_char (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                     char        
);
procedure column_value_char (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                     char        ,
 column_error                      out                   number        ,
 actual_length                     out               number(38)        
);

column_value_long

procedure column_value_long (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 length                             in               number(38)        ,
 offset                             in               number(38)        ,
 value                             out                 varchar2        ,
 value_length                      out               number(38)        
);

column_value_raw

procedure column_value_raw (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                      raw        
);
procedure column_value_raw (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                      raw        ,
 column_error                      out                   number        ,
 actual_length                     out               number(38)        
);

column_value_rowid

procedure column_value_rowid (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                    rowid        
);
procedure column_value_rowid (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 value                             out                    rowid        ,
 column_error                      out                   number        ,
 actual_length                     out               number(38)        
);

define_array

procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 n_tab                              of                    table  number,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 c_tab                              of                    table varchar2,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 d_tab                              of                    table    date,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 bl_tab                             of                    table    blob,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 cl_tab                             of                    table    clob,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 bf_tab                             of                    table  binary,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 ur_tab                             of                    table   rowid,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 tm_tab                             of                    table    time,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 tms_tab                            of                    table timestamp,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 ttz_tab                            of                    table    time,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 tstz_tab                           of                    table timestamp,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 tstz_tab                           of                    table timestamp,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 iym_tab                            of                    table interval,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 ids_tab                            of                    table interval,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 bflt_tab                           of                    table binary_float,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);
procedure define_array (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 bdbl_tab                           of                    table binary_double,
 cnt                                in               number(38)        ,
 lower_bound                        in               number(38)        
);

define_column

procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                   number        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                 varchar2        ,
 column_size                        in               number(38)        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                     date        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                     blob        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                     clob        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                           file                   binary     lob
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                    rowid        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                     time        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                timestamp        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                           with                     time    time
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                           with                timestamp    time
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                           with                timestamp   local
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                           year                 interval      to
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                            day                 interval      to
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in             binary_float        
);
procedure define_column (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in            binary_double        
);

define_column_char

procedure define_column_char (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                     char        ,
 column_size                        in               number(38)        
);

define_column_long

procedure define_column_long (
 c                                  in               number(38)        ,
 position                           in               number(38)        
);

define_column_raw

procedure define_column_raw (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                      raw        ,
 column_size                        in               number(38)        
);

define_column_rowid

procedure define_column_rowid (
 c                                  in               number(38)        ,
 position                           in               number(38)        ,
 column                             in                    rowid        
);

describe_columns

procedure describe_columns (
 c                                  in               number(38)        ,
 col_cnt                           out               number(38)        ,
 desc_t                             of                    table  record
);

describe_columns2

procedure describe_columns2 (
 c                                  in               number(38)        ,
 col_cnt                           out               number(38)        ,
 desc_t                             of                    table  record
);

execute

function execute returns number(38) (
 c                                  in               number(38)        
);

execute_and_fetch

function execute_and_fetch returns number(38) (
 c                                  in               number(38)        ,
 exact                              in                  boolean default
);

fetch_rows

function fetch_rows returns number(38) (
 c                                  in               number(38)        
);

is_open

function is_open returns boolean (
 c                                  in               number(38)        
);

last_error_position

function last_error_position returns number(38) (
);

last_row_count

function last_row_count returns number(38) (
);

last_row_id

function last_row_id returns rowid (
);

last_sql_function_code

function last_sql_function_code returns number(38) (
);

open_cursor

function open_cursor returns number(38) (
);

parse

procedure parse (
 c                                  in               number(38)        ,
 statement                          in                 varchar2        ,
 language_flag                      in               number(38)        
);
procedure parse (
 c                                  in               number(38)        ,
 statement                          of                    table varchar2,
 lb                                 in               number(38)        ,
 ub                                 in               number(38)        ,
 lfflg                              in                  boolean        ,
 language_flag                      in               number(38)        
);
procedure parse (
 c                                  in               number(38)        ,
 statement                          of                    table varchar2,
 lb                                 in               number(38)        ,
 ub                                 in               number(38)        ,
 lfflg                              in                  boolean        ,
 language_flag                      in               number(38)        
);
language_flag is one of
  • dbms_sql.v6
  • dbms_sql.native
  • dbms_sql.v7

variable_value

procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                   number        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                 varchar2        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                     date        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                     blob        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                     clob        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            file                   binary     lob
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table  number
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table varchar2
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table    date
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table    blob
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table    clob
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table  binary
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                    rowid        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table   rowid
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                     time        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table    time
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                timestamp        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table timestamp
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            with                     time    time
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table    time
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            with                timestamp    time
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table timestamp
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            with                timestamp   local
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table timestamp
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                            year                 interval      to
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table interval
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             day                 interval      to
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table interval
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out             binary_float        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table binary_float
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out            binary_double        
);
procedure variable_value (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                              of                    table binary_double
);

variable_value_char

procedure variable_value_char (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                     char        
);

variable_value_raw

procedure variable_value_raw (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                      raw        
);

variable_value_rowid

procedure variable_value_rowid (
 c                                  in               number(38)        ,
 name                               in                 varchar2        ,
 value                             out                    rowid        
);

An Example

Prior to 8.1 (I believe), it was not possible to use execute immediate in order to call a dynamic SQL statement. One had to use dbms_sql. Here's a short script that shows a basic use:
declare
  stmt  integer;
  dummy integer;
begin
  stmt := dbms_sql.open_cursor;
  dbms_sql.parse(stmt, 'create table xyz (abc number)',dbms_sql.v7);
  dummy := dbms_sql.execute(stmt);
  dbms_sql.close_cursor(stmt);
end;
/