22 APEX_EXEC

The APEX_EXEC package encapsulates data processing and querying capabilities and provides an abstraction from the data source to APEX components and plug-ins. APEX_EXEC contains procedures and functions to execute queries or procedural calls on local and remote data sources as well as REST Data Sources. It can be used for plug-in development and procedural PL/SQL processing in applications or within packages and procedures.

All APEX_EXEC procedures require an existing APEX session to function. In a pure SQL or PL/SQL context, use the APEX_SESSION package to initialize a new session.

Note:

Always add an exception handler to your procedure or function to ensure that APEX_EXEC.CLOSE is always called to release server resources such as database cursors and temporary lobs.

• Call Sequences for APEX_EXEC
  
• Global Constants
  
• Data Types
  
• ADD_COLUMN Procedure
  
• ADD_DML_ROW Procedure
  
• ADD_FILTER Procedure
  
• ADD_ORDER_BY Procedure
  
• ADD_PARAMETER Procedure
  
• CLEAR_DML_ROWS Procedure
  
• CLOSE Procedure
  
• COPY_DATA Procedure
  
• EXECUTE_DML Procedure
  
• EXECUTE_PLSQL Procedure
  
• EXECUTE_REMOTE_PLSQL Procedure
  
• EXECUTE_REST_SOURCE Procedure
  
• EXECUTE_WEB_SOURCE Procedure (Deprecated)
  
• GET Functions
  
• GET_COLUMN Function
  
• GET_COLUMN_COUNT Function
  
• GET_COLUMN_POSITION Function
  
• GET_DATA_TYPE Function
  
• GET_DML_STATUS_CODE Function
  
• GET_DML_STATUS_MESSAGE Function
  
• GET_PARAMETER Functions
  
• GET_ROW_VERSION_CHECKSUM Function
  
• GET_TOTAL_ROW_COUNT Function
  
• HAS_ERROR Function
  
• HAS_MORE_ROWS Function
  
• IS_REMOTE_SQL_AUTH_VALID Function
  
• NEXT_ROW Function
  
• OPEN_LOCAL_DML_CONTEXT Function
  
• OPEN_QUERY_CONTEXT Function Signature 1
  
• OPEN_QUERY_CONTEXT Function Signature 2
  
• OPEN_REMOTE_DML_CONTEXT Function
  
• OPEN_REMOTE_SQL_QUERY Function
  
• OPEN_REST_SOURCE_DML_CONTEXT Function
  
• OPEN_REST_SOURCE_QUERY Function
  
• OPEN_WEB_SOURCE_DML_CONTEXT Function (Deprecated)
  
• OPEN_WEB_SOURCE_QUERY Function (Deprecated)
  
• PURGE_REST_SOURCE_CACHE Procedure
  
• PURGE_WEB_SOURCE_CACHE Procedure (Deprecated)
  
• SET_CURRENT_ROW Procedure
  
• SET_NULL Procedure
  
• SET_ROW_VERSION_CHECKSUM Procedure
  
• SET_VALUE Procedure
  
• SET_VALUES Procedure