Results for FORALL


1 to 20 of 41 results. Prev  Next
Results per page:   20  | 40


User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 22 of 52

FORALL StatementThe FORALL statement instructs the PL/SQL engine to bulk-bind input collections before sending them … to the SQL engine. Although the FORALL statement contains an iteration scheme, it is not a FOR loop

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 1 of 52

FORALL StatementFunctions GOTO Statement

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

How FORALL Affects RollbacksIn a FORALL statement, if any execution of the SQL statement raises an unhandled exception, all … (10, 20, 30); BEGIN FORALL j IN depts.FIRST..depts.LAST UPDATE emp2 SET job = job || ' (temp)' WHERE … the SQL statement raises an exception, the FORALL statement halts. In our example, the second

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Using the FORALL StatementThe keyword FORALL instructs the PL/SQL engine to bulk-bind input collections before sending them … to the SQL engine. Although the FORALL statement contains an iteration scheme, it is not a FOR loop … . Its syntax follows: FORALL index IN lower_bound..upper_bound sql_statement; The index can be … referenced only within the FORALL

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Using FORALL and BULK COLLECT TogetherYou can combine the BULK COLLECT clause with a FORALL statement, in which case, the SQL engine bulk … completes: FORALL j IN depts.FIRST..depts.LAST DELETE FROM emp WHERE empno = depts(j) RETURNING empno … ... BULK COLLECT statement in a FORALL statement. Otherwise, you get the error implementation … restriction: cannot use FORALL

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Handling FORALL Exceptions with the %BULK_EXCEPTIONS AttributePL/SQL provides a mechanism to handle exceptions raised during the execution of a FORALL statement … processing. To have a bulk bind complete despite errors, add the keywords SAVE EXCEPTIONS to your FORALL … statement. The syntax follows: FORALL index IN lower_bound..upper_bound SAVE EXCEPTIONS … first field, %BULK_EXCEPTIONS(i).ERROR_INDEX,

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Counting Rows Affected by FORALL Iterations with the %BULK_ROWCOUNT Attributeattribute, %BULK_ROWCOUNT, designed for use with the FORALL statement. This attribute has the … , 20, 50); BEGIN FORALL j IN depts.FIRST..depts.LAST UPDATE emp SET sal = sal * 1.10 WHERE deptno … ; The FORALL statement and %BULK_ROWCOUNT attribute use the same subscripts. For example, if FORALL … , %BULK_ROWCOUNT

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00432 implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statementsCause: SELECT statement contains both the FORALL and BULK COLLECT INTO phrases. Action: Do not use … FORALL and BULK COLLECT INTO together in SELECT statements.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00435 DML statement without BULK In-BIND cannot be used inside FORALLCause: The DML (SELECT/INSERT/DELETE/UPDATE) statement inside the FORALL statement does not contain … BULK IN-BIND variables. Action: The DML (SELECT/INSERT/DELETE/UPDATE) statement inside the FORALL statement must contain BULK IN-BIND variables.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00430 FORALL iteration variable string is not allowed in this contextCause: FORALL iteration variable can only be used as a subscript. It cannot be used directly or as … a part of an expression. Action: Use FORALL variable only as a collection subscript.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00437 FORALL bulk index cannot be used in string clauseCause: RETURNING table(bulk_index) is not supported. Action: Use RETURNING BULK COLLECT instead.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 22 of 52

Usage Notesonly to subscripted collections. If a FORALL statement fails, database changes are rolled back to an … implicit savepoint marked before each execution of the SQL statement. Changes made during previous iterations of the FORALL loop are not rolled back.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 22 of 52

Keyword and Parameter Descriptionindex_name This is an undeclared identifier that can be referenced only within the FORALL statement … statement. Inside a FORALL statement, index_name cannot appear in expressions and cannot be assigned a … expressions are evaluated only when the FORALL statement is first entered. SAVE EXCEPTIONS These … optional keywords cause

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 22 of 52

Example-- fill varray here... FORALL j IN 6..10 -- bulk-bind middle third of varray UPDATE emp SET sal … the function median: FORALL i IN 1..20 INSERT INTO emp2 VALUES (enums(i), names(i), median(sals),...);

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 22 of 52

RestrictionsThe following restrictions apply to the FORALL statement: You cannot loop through the elements of … an associative array that has a string type for the key. Within a FORALL loop, you cannot refer to … the FORALL statement only in server-side programs (not in client-side programs). Otherwise, you get … statement must reference

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

How Do Bulk Binds Improve Performance?FORALL statement. To do bulk binds with SELECT statements, you include the BULK COLLECT clause in … statements, see \"FORALL Statement\" and \"SELECT INTO Statement\". Example: Performing a Bulk Bind … (10, 30, 70); -- department numbers BEGIN FORALL i IN depts.FIRST..depts.LAST DELETE FROM emp WHERE … table twice: first using

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Oracle9i Application Developer's Guide - Fundamentals -- Index

FEACH ROW clause, 15-11 FORALL statement FORALL statement using, 9-18 foreign key constraints foreign

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 15 of 52

Examples; You can combine the BULK COLLECT clause with a FORALL statement, in which case, the SQL engine bulk … completes: FORALL j IN depts.FIRST..depts.LAST DELETE FROM emp WHERE deptno = depts(j) RETURNING empno

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 48 of 52

SQL Cursorand %BULK_EXCEPTIONS, designed for use with the FORALL statement. For more information, see \"Managing Cursors\".

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Native Dynamic SQL

Syntax for Dynamic Bulk Bindsdynamic bulk binds: EXECUTE IMMEDIATE, FETCH, and FORALL. Bulk EXECUTE IMMEDIATE This statement lets … number of columns in the query select-list, Oracle generates an error. Bulk FORALL This statement lets … IMMEDIATE statement inside a FORALL loop. The syntax follows: FORALL index IN lower bound..upper bound


Was this page helpful?