GET_QUERY Procedure

GET_QUERY returns the text of the queries that are used by FETCH_xxx. This function assists in debugging.

Syntax

FUNCTION get_query
  (handle IN NUMBER)
   RETURN VARCHAR2;

Parameters

Table 28-7 GET_QUERY Parameters

Parameter	Description
handle	The handle returned from OPEN.

Returns

The text of the queries that will be used by FETCH_xxx.

Exceptions

• INVALID_ARGVAL. A NULL or invalid value was supplied for the handle parameter.