8.30 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