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

0: jdbc:sqlstream:sdp://drew-VirtualBox> SELECT * 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'
'DESCRIPTION 'Plugin to wrap new-style streaming adapters';'