ADD_DATA_SOURCE Procedure

This procedure creates a data source which identifies a table or query from which you can source data values.

Syntax

APEX_DG_DATA_GEN.ADD_DATA_SOURCE (
    p_blueprint             IN VARCHAR2,
    p_name                  IN VARCHAR2,
    p_data_source_type      IN VARCHAR2,
    p_table                 IN VARCHAR2 DEFAULT NULL,
    p_preserve_case         IN VARCHAR2 DEFAULT 'N',
    p_sql_query             IN VARCHAR2 DEFAULT NULL,
    p_where_clause          IN VARCHAR2 DEFAULT NULL,
    p_inline_data           IN CLOB     DEFAULT NULL,
    p_order_by_column       IN VARCHAR2 DEFAULT NULL,
    p_data_source_id        OUT NUMBER )

Parameters

Parameter	Description
`p_blueprint`	Identifies the blueprint.
`p_name`	Name of a data source. Name is upper cased and must be 26 characters or less.
`p_data_source_type`	`TABLE` or `SQL_QUERY`.
`p_table`	For `source type = TABLE`. Typically this will match `p_name`.
`p_preserve_case`	Defaults to `N` which forces `p_table_name` to uppercase, if `Y` preserves casing of `p_table`.
`p_sql_query`	For `p_data_source_type = SQL_QUERY`.
`p_where_clause`	For `p_data_source_type = TABLE`, this adds the `where` clause. Do not include "where" keyword (for example, `deptno <= 20`).
`p_inline_data`	For `p_data_source_type = JSON_DATA`.
`p_order_by_column`	Not used.
`p_data_source`	The ID of the added data source (`OUT`).

Example

DECLARE
  l_data_source_id number;
BEGIN
    apex_dg_data_gen.add_data_source(
                 p_blueprint           => 'Cars',
                 p_name                => 'apex_dg_builtin_cars',
                 p_data_source_type    => 'TABLE',
                 p_table               => 'apex_dg_builtin_cars',
                 p_data_source_id      => l_data_source_id  );
END;