You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for GOTO


1 to 20 of 197 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

PL/SQL Control Structures

GOTO StatementThe GOTO statement branches to a label unconditionally. The label must be unique within its scope … and must precede an executable statement or a PL/SQL block. When executed, the GOTO statement … statement farther down in a sequence of statements: BEGIN... GOTO insert_row;... > INSERT INTO emp … : BEGIN... > BEGIN UPDATE emp SET......

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

PL/SQL Language Elements, 24 of 52

GOTO StatementThe GOTO statement branches unconditionally to a statement label or block label. The label must be … unique within its scope and must precede an executable statement or a PL/SQL block. The GOTO … statement transfers control to the labelled statement or block. For more information, see "GOTO Statement".

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Developing Programs, 7 of 12

Alternatives to the GOTO CommandWhile GOTO makes it easy to branch within a program, frequent use of it can obscure the logic of … complex program with several labels and GOTO commands that skip over large portions of code. To keep the … logic of your programs clear, minimize your use of GOTO. Sometimes a GOTO command is the best … programming

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

PL/SQL Control Structures

Sequential Control: GOTO and NULL StatementsUnlike the IF and LOOP statements, the GOTO and NULL statements are not crucial to PL/SQL … programming. The structure of PL/SQL is such that the GOTO statement is seldom needed. Occasionally, it can … meaning and action of conditional statements clear. Overuse of GOTO statements can result in complex … , use GOTO

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

PL/SQL Language Elements, 1 of 52

FORALL StatementFunctions GOTO Statement

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00375 illegal GOTO statement; this GOTO cannot branch to label ' string 'Cause: The line and column numbers accompanying the error message refer to a GOTO that branches … the GOTO statement inside the sequence of statements or move the labeled statement outside the sequence of statements.

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

PL/SQL Control Structures

Iterative Control: LOOP and EXIT StatementsSequential Control: GOTO and NULL Statements

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

Handling PL/SQL Errors

Branching to or from an Exception HandlerA GOTO statement cannot branch into an exception handler. Also, a GOTO statement cannot branch from … an exception handler into the current block. For example, the following GOTO statement is illegal … ('XYZ', pe_ratio); EXCEPTION WHEN ZERO_DIVIDE THEN pe_ratio:= 0; GOTO my_label; -- illegal branch … into current

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

PL/SQL Language Elements, 24 of 52

ExamplesA GOTO label cannot precede just any keyword. It must precede an executable statement or a PL/SQL … block. For example, the following GOTO statement is not allowed: FOR ctr IN 1..50 LOOP DELETE FROM … emp WHERE... IF SQL%FOUND THEN GOTO end_loop; -- not allowed END IF;... > END LOOP; -- not an … ..50 LOOP DELETE FROM emp WHERE...

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

PL/SQL Language Elements, 24 of 52

Usage NotesSome possible destinations of a GOTO statement are not allowed. In particular, a GOTO statement … cannot branch into an IF statement, LOOP statement, or sub-block. For example, the following GOTO … statement is not allowed: BEGIN... GOTO update_row; -- can't branch into IF statement... IF valid THEN … ... > UPDATE

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

PL/SQL Language Elements, 24 of 52

Keyword and Parameter Description… You use a GOTO statement to transfer control to the statement or block following >.

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Error Handling and Diagnostics

Scope of WHENEVERGOTO DO_DELETE; DO J = 1 TO N_FETCH; EXEC SQL FETCH EMP_CURSOR INTO:MY_ENAME,:MY_SAL;... END … FOUND condition properly by resetting the GOTO target: /* Proper use of WHENEVER */ EXEC SQL WHENEVER … NOT FOUND GOTO DO_DELETE; DO J = 1 TO N_FETCH; EXEC SQL FETCH EMP_CURSOR INTO:MY_ENAME,:MY_SAL … ;... END; DO_DELETE: EXEC SQL WHENEVER

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Handling Runtime Errors

Guidelines for WHENEVERSQLERROR GOTO directive branches to an error handling routine that includes an executable SQL statement … : EXEC SQL WHENEVER SQLERROR GOTO sql_error;... sql_error: EXEC SQL WHENEVER SQLERROR CONTINUE; EXEC … FOUND GOTO no_more; for (;;) { EXEC SQL FETCH emp_cursor INTO:emp_name,:salary;... } no_more: EXEC … properly by resetting

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

FETCH A Row from the Active Setby the SQLDV elements:... EXEC SQL WHENEVER NOT FOUND GOTO N_FND; NXT_ROW: EXEC SQL FETCH … EMP_CURSOR USING DESCRIPTOR SELDSC; CALL PRINT_ROW(SELDSC); /* proc. to print values */ GOTO NXT_ROW; N_FND

Objects for OLE, 9i Release 2 (9.2.0.2)

ConnectSession Method Example

ConnectSession Method Examplenot exist 'an error is generated. On Error GoTo SetName Set OraSession = dfltsess.ConnectSession … ("ExampleSession") On Error GoTo 0 'You can specify other processing here, such as creating a

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

Large Objects: Advanced Topics

OCI Example of LOB Buffering(.., lbs_loc1, offset, &amount, buffer, bufl,..); if (exception) goto exception_handler; -- This will … ); OCILobWrite(.., lbs_loc2, offset, amount, buffer, bufl,..); if (exception) goto exception_handler … ) goto exception_handler; -- Read directly from page_A into the user buffer. -- There is no round-trip … = populate_buffer(20480);

Reference Guide for Informix Dynamic Server Migrations, 9i Release 2 (9.2.0.2)

The ESQL/C to Oracle Pro*C Converter

Oracle Pro*C Conversionadditional directives. */ EXEC SQL WHENEVER SQLERROR GOTO connecterror; /* ESQL-CONV-ERR:(CONNECT) Manual … :(WHENEVER) Oracle supports additional directives. */ EXEC SQL WHENEVER SQLERROR GOTO declareerror … directives. */ EXEC SQL WHENEVER SQLERROR GOTO openerror; /* Open the cursor. */ EXEC SQL OPEN salespeople … WHENEVER SQLERROR

Pro*COBOLĀ® Programmer's Guide, 9i Release 2 (9.2.0.2)

Precompiler Concepts

Paragraph and Section Names… .. DO or WHENEVER... GOTO statement, as the next example shows: PROCEDURE DIVISION. MAIN. EXEC SQL

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

PL/SQL Language Elements, 29 of 52

Usage Notesis closed automatically even if you use an EXIT or GOTO statement to exit the loop prematurely. The

SQL*Module for Ada Programmer's Guide, 9i Release 2 (9.2.0.2)

Accessing Stored Procedures

PL/SQLcontrol execution flow, using IF... THEN... ELSE, EXIT, GOTO, and other procedural constructs create