For information on how to perform these tasks, see "Returning PL/SQL Cursor Variables".
Creates a dynaset from a PL/SQL cursor using custom cache and fetch parameters. The SQL statement should be a stored procedure or anonymous block. The resulting dynaset is read-only. Attempting to set the SQL property results in an error. The dynaset can be refreshed with new parameters.
set OraDynaset = CreatePlsqlCustomDynaset(SQLStatement, CursorName, options, slicesize, perblock, blocks, FetchLimit, FetchSize)
The arguments for the method are:
||Any valid Oracle PL/SQL stored procedure or anonymous block.|
||Name of the cursor created in the PL/SQL stored procedure.|
||A bit flag indicating the status of any optional states of the dynaset. You can combine one or more options by adding their respective values.|
||Cache slice size.|
||Cache slices for each block.|
||Cache maximum number of blocks.|
||Fetch array size.|
||Fetch array buffer size.|
The options flag values are:
||Accept the default behavior.|
||Do not perform automatic binding of database parameters.|
||Do not remove trailing blanks from character string data retrieved from the database.|
||Do not create a local dynaset data cache. Without the local cache, previous rows within a dynaset are unavailable; however, increased performance results during retrieval of data from the database (move operations) and from the rows (field operations). Use this option in applications that make single passes through the rows of a dynaset for increased performance and decreased resource use.|
||Do not force a
These values can be found in the
The SQL statement must be a PL/SQL stored procedure with
END around the call, as if it were executed as an anonymous PL/SQL block; otherwise, an error is returned. The
CursorName argument should exactly match the cursor created inside the stored procedure or anonymous PL/SQL block; otherwise an error is returned. The cursor created inside the stored procedure should represent a valid SQL
You do not need to bind the PL/SQL cursor variable using the
Add method if the stored procedure returns a cursor as an output parameter. You can still use PL/SQL bind variables in conjunction with the
This method automatically moves to the first row of the created dynaset.
ORADYN_DIRTY_WRITE options have no effect on the dynaset creation.