1. API Reference
  2. APEX_APPLICATION_INSTALL
  3. GET_REMOTE_SERVER_SQL_MODE Function

8.29 GET_REMOTE_SERVER_SQL_MODE Function

This function gets the SQL mode to be used for a given remote MySQL server during application import.

Syntax

APEX_APPLICATION_INSTALL.GET_REMOTE_SERVER_SQL_MODE (
    p_static_id IN VARCHAR2 )
    RETURN VARCHAR2;

Parameters

Parameter Description
p_static_id Static ID to reference the remote server object..

Example

DECLARE
    l_default_database varchar2(255);
BEGIN
    l_default_database := apex_application_install.get_remote_server_sql_mode( 'MY_REMOTE_SERVER' );
END;

Note:

SET_REMOTE_SERVER Procedure

Parent topic: APEX_APPLICATION_INSTALL