24.12 GET_BP_TABLE_ID Function
This function returns the table_id
for a given blueprint ID and table name (case-sensitive). If not found, it searches with UPPERCASE p_table_name
automatically.
Syntax
APEX_DG_DATA_GEN.GET_BP_TABLE_ID (
p_bp_id IN NUMBER,
p_table_name IN VARCHAR2 )
RETURN NUMBER;
Parameters
Parameter | Description |
---|---|
p_bp_id |
The blueprint ID. |
p_table_name |
The name of the table. |
Returns
The table ID.
Example
DECLARE
v_table_id number;
BEGIN
l_table_id := apex_dg_data_gen.get_bp_table_id
(p_bp_id => 12345,
p_table_name => 'DEPT'
);
END;
Parent topic: APEX_DG_DATA_GEN