Results for NO_DATA_FOUND


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


Packages and Types Reference, 10g Release 1 (10.1)

155 UTL_FILE

ExceptionsINVALID_FILEHANDLE INVALID_OPERATION READ_ERROR NO_DATA_FOUND VALUE_ERROR

Packages and Types Reference, 10g Release 1 (10.1)

152 UTL_COMPRESS

Exceptionsno_data_found - finished uncompress. invalid_handle - out of range invalid or uninitialized handle. invalid_argument - NULL handle.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

DISABLED Function

ExceptionsTable 14-11 DISABLED Function Exceptions Exception Description NO_DATA_FOUND Specified destination does not appear in the DEFSCHEDULE view.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

GET_CALL_ARGS Procedure

ExceptionsTable 13-9 GET_CALL_ARGS Procedure Exceptions Exception Description NO_DATA_FOUND Input parameters

Advanced Replication Management API Reference, 10g Release 1 (10.1)

GET_ARG_FORM Function

ExceptionsTable 13-3 GET_ARG_FORM Function Exceptions Exception Description NO_DATA_FOUND Input parameters do not correspond to a parameter of a deferred call.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

GET_ARG_TYPE Function

ExceptionsTable 13-6 GET_ARG_TYPE Function Exceptions Exception Description NO_DATA_FOUND Input parameters do not correspond to a parameter of a deferred call.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

GET_OBJECT_NULL_VECTOR_ARG Function

ExceptionsTable 13-13 GET_OBJECT_NULL_VECTOR_ARG Function Exceptions Exception Description NO_DATA_FOUND

Packages and Types Reference, 10g Release 1 (10.1)

38 DBMS_HS_PASSTHROUGH

FETCH_ROW Function… When there are no more rows to be fetched, the exception NO_DATA_FOUND is raised. Before the rows

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

READ Procedure, then amount is set to 0, and a NO_DATA_FOUND exception is raised.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

GET_ datatype _ARG Function

ExceptionsTable 13-11 GET_ datatype _ARG Function Exceptions Exception Description NO_DATA_FOUND Input

Advanced Replication Management API Reference, 10g Release 1 (10.1)

UNSCHEDULE_PUSH Procedure

Parametersprocedure calls. Table 14-33 UNSCHEDULE_PUSH Procedure Exceptions Exception Description NO_DATA_FOUND No

Advanced Replication Management API Reference, 10g Release 1 (10.1)

TRANSACTION Procedure

Parametersno_data_found exception is raised. The data in the table is case insensitive.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

SET_DISABLED Procedure

ExceptionsTable 14-29 SET_DISABLED Procedure Exceptions   Exception Description NO_DATA_FOUND No entry was

Packages and Types Reference, 10g Release 1 (10.1)

38 DBMS_HS_PASSTHROUGH

ExceptionsTable 38-25 GET_VALUE_RAW Procedure Exceptions Exception Description ORA-1403 Returns NO_DATA_FOUND

Packages and Types Reference, 10g Release 1 (10.1)

38 DBMS_HS_PASSTHROUGH

ExceptionsTable 38-23 GET_VALUE Procedure Exceptions Exception Description ORA-1403 Returns NO_DATA_FOUND

User's Guide and Reference, 10g Release 1 (10.1)

G Frequently Asked Questions About PL/SQL

How Do I Continue After a PL/SQL Exception?that might raise NO_DATA_FOUND, or around arithmetic operations that might raise DIVIDE_BY_ZERO. By

User's Guide and Reference, 10g Release 1 (10.1)

10 Handling PL/SQL Errors

Using Locator Variables to Identify Exception Locationstable_name LIKE 'XYZ%'; EXCEPTION WHEN NO_DATA_FOUND THEN dbms_output.put_line('Table name not found in query ' || stmt); END; /

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Avoiding Collection Exceptions; -- raises NO_DATA_FOUND (5) END; / In the first case, the nested table is atomically . In the second … . NO_DATA_FOUND a subscript designates an element that was deleted, or a nonexistent element of an … NO_DATA_FOUND: DECLARE TYPE NumList IS TABLE OF NUMBER; nums NumList:= NumList(10,20,30 … NO_DATA_FOUND dbms_output.put_line(nums.COUNT);

Packages and Types Reference, 10g Release 1 (10.1)

155 UTL_FILE

Usage Notesto end of file, the NO_DATA_FOUND exception is raised. If the file is opened for byte mode

User's Guide, 10g Release 1 (10.1)

8 Tuning Tips for the DBA

8.6 Reading Data from an ORDVideo Object Using the readFromSource( ) Method in a PL/SQL Script/SQL script until no more data is found. The procedure then returns a NO_DATA_FOUND exception when … NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('End of data '); DBMS_OUTPUT.PUT_LINE('doing read '|| read_cnt


Was this page helpful?