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