GENERATE_DDL_FOR_WRAPPER

Generates DDL for named data wrapper. See CREATE LOCAL DATA WRAPPER or CREATE FOREIGN DATA WRAPPER for details.

Syntax

SYS_BOOT.MGMT.GENERATE_DDL_FOR_WRAPPER(wrapper_name);

where wrapper_name is name of wrapper, such as “ECDA” in the example below.

CREATE OR REPLACE FOREIGN DATA WRAPPER ECDA LIBRARY 'class com.sqlstream.aspen.namespace.common.CommonDataWrapper''
'LANGUAGE JAVA;

Example

SELECT STATEMENT FROM TABLE (SYS_BOOT.MGMT.GENERATE_DDL_FOR_WRAPPER('ECDA'));
'STATEMENT'
'CREATE OR REPLACE FOREIGN DATA WRAPPER ECDA LIBRARY 'class com.sqlstream.aspen.namespace.common.CommonDataWrapper''
'LANGUAGE JAVA;'