PL/SQL Packages DBMS_SQL

Dynamic SQL statements, including data manipulation language (DML) or data definition language (DDL) statements.

Subprocedures:

OPEN_CURSOR Function 
               Returns cursor ID number of new cursor. 

PARSE          Parse given statement. 

BIND_VARIABLE  Bind a given value to a given variable or collection. 
BIND_ARRAY     Bind a given value to a given variable or collection. 

DEFINE_COLUMN
DEFINE_COLUMN_LONG
               Define a column to be selected from the given cursor,
               used only with SELECT statements. 

DEFINE_ARRAY   Define a collection to be selected from the given cursor,
               used only with SELECT statements. 

EXECUTE Function 
               Execute a given cursor. 

EXECUTE_AND_FETCH Function 
               Execute a given cursor and fetch rows. 

FETCH_ROWS Function 
               Fetch a row from a given cursor. 

COLUMN_VALUE   Returns value of the cursor element
               for a given position in a cursor. 

COLUMN_VALUE_LONG 
               Returns a selected part of a LONG column,
               that has been defined using DEFINE_COLUMN_LONG. 

VARIABLE_VALUE Returns value of named variable for given cursor. 

IS_OPEN Function 
               Returns TRUE if given cursor is open. 

DESCRIBE_COLUMNS
               Describe the columns for a cursor opened and parsed through DBMS_SQL. 

CLOSE_CURSOR   Close given cursor and frees memory. 

LAST_ERROR_POSITION Function 
               Return byte offset in the SQL statement text where the error occurred. 

LAST_ROW_COUNT Function 
               Returns cumulative count of the number of rows fetched. 

LAST_ROW_ID Function 
               Returns ROWID of last row processed. 

LAST_SQL_FUNCTION_CODE Function 
               Returns SQL function code for statement.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al

Related:

EXECUTE IMMEDIATE


 
Copyright © 1999-2024 SS64.com
Some rights reserved