SQL> --------------------------------------------------------

SQL> -- File created - 2019-09-16

SQL> -- Created by: INDRA
SQL> --------------------------------------------------------
SQL>
SQL> SET TIMI ON
SQL> SET ECHO ON
SQL> SET FEEDB ON
SQL> DEFINE var1 = "TDMI_STA.";
SQL> SPOOL 01_DDL_P133_F13301_STA_LOG.log;
SQL>
SQL>
SQL> --------------------------------------------------------
SQL> -- DDL FOR TYPE TP_LINE_P133_13301_RENGAS_WS
SQL> --------------------------------------------------------
SQL> BEGIN
2 EXECUTE IMMEDIATE 'DROP TYPE &var1.TP_TAB_P133_13301_RENGAS_WS FORCE';
3 EXCEPTION
4 WHEN OTHERS THEN
5 IF SQLCODE != -04043 THEN
6 RAISE;
7 END IF;
8 END;
9 /
old:BEGIN
EXECUTE IMMEDIATE 'DROP TYPE &var1.TP_TAB_P133_13301_RENGAS_WS FORCE';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -04043 THEN
RAISE;
END IF;
END;

new:BEGIN
EXECUTE IMMEDIATE 'DROP TYPE TDMI_STA.TP_TAB_P133_13301_RENGAS_WS FORCE';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -04043 THEN
RAISE;
END IF;
END;

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.016
SQL>
SQL> BEGIN
2 EXECUTE IMMEDIATE 'DROP TYPE &var1.TP_LINE_P133_13301_RENGAS_WS FORCE';
3 EXCEPTION
4 WHEN OTHERS THEN
5 IF SQLCODE != -04043 THEN
6 RAISE;
7 END IF;
8 END;
9 /
old:BEGIN
EXECUTE IMMEDIATE 'DROP TYPE &var1.TP_LINE_P133_13301_RENGAS_WS FORCE';
EXCEPTION
WHEN OTHERS THEN
 IF SQLCODE != -04043 THEN
RAISE;
END IF;
END;

new:BEGIN
EXECUTE IMMEDIATE 'DROP TYPE TDMI_STA.TP_LINE_P133_13301_RENGAS_WS FORCE';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -04043 THEN
RAISE;
END IF;
END;

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.017
SQL>
SQL> create or replace TYPE &var1.TP_LINE_P133_13301_RENGAS_WS AS OBJECT
2 (
3 IDENTIFICATION VARCHAR2(50 CHAR),
4 VERSION VARCHAR2(50 CHAR),
5 "TYPE" VARCHAR2(50 CHAR),
6 CREATION_DATETIME VARCHAR2(50 CHAR),
7 CONTRACT_REF VARCHAR2(50 CHAR),
8 ISSUER_ID VARCHAR2(50 CHAR),
9 ISSUER_MARKET_CODE VARCHAR2(50 CHAR),
10 RECIPIENT_ID VARCHAR2(50 CHAR),
11 RECIPIENT_MARKET_CODE VARCHAR2(50 CHAR),
12 APPLICATION_CTX VARCHAR2(50 CHAR),
13 METER_ID VARCHAR2(50 CHAR),
14 MEASURE_UNIT_CODE VARCHAR2(50 CHAR),
15 TIME_INTERVAL VARCHAR2(50 CHAR),
16 DATE_UTC VARCHAR2(50 CHAR),
17 DIRECTION_CODE VARCHAR2(50 CHAR),
18 STATUS_CODE VARCHAR2(50 CHAR),
19 QUANTITY_AMOUNT VARCHAR2(50 CHAR)
20 );
21 /
old:create or replace TYPE &var1.TP_LINE_P133_13301_RENGAS_WS AS OBJECT
(
IDENTIFICATION VARCHAR2(50 CHAR),
VERSION VARCHAR2(50 CHAR),
"TYPE" VARCHAR2(50 CHAR),
CREATION_DATETIME VARCHAR2(50 CHAR),
CONTRACT_REF VARCHAR2(50 CHAR),
ISSUER_ID VARCHAR2(50 CHAR),
ISSUER_MARKET_CODE VARCHAR2(50 CHAR),
RECIPIENT_ID VARCHAR2(50 CHAR),
RECIPIENT_MARKET_CODE VARCHAR2(50 CHAR),
APPLICATION_CTX VARCHAR2(50 CHAR),
METER_ID VARCHAR2(50 CHAR),
MEASURE_UNIT_CODE VARCHAR2(50 CHAR),
TIME_INTERVAL VARCHAR2(50 CHAR),
DATE_UTC VARCHAR2(50 CHAR),
DIRECTION_CODE VARCHAR2(50 CHAR),
STATUS_CODE VARCHAR2(50 CHAR),
QUANTITY_AMOUNT VARCHAR2(50 CHAR)
);
new:create or replace TYPE TDMI_STA.TP_LINE_P133_13301_RENGAS_WS AS OBJECT
(
IDENTIFICATION VARCHAR2(50 CHAR),
VERSION VARCHAR2(50 CHAR),
"TYPE" VARCHAR2(50 CHAR),
CREATION_DATETIME VARCHAR2(50 CHAR),
CONTRACT_REF VARCHAR2(50 CHAR),
ISSUER_ID VARCHAR2(50 CHAR),
ISSUER_MARKET_CODE VARCHAR2(50 CHAR),
RECIPIENT_ID VARCHAR2(50 CHAR),
RECIPIENT_MARKET_CODE VARCHAR2(50 CHAR),
APPLICATION_CTX VARCHAR2(50 CHAR),
METER_ID VARCHAR2(50 CHAR),
MEASURE_UNIT_CODE VARCHAR2(50 CHAR),
TIME_INTERVAL VARCHAR2(50 CHAR),
DATE_UTC VARCHAR2(50 CHAR),
DIRECTION_CODE VARCHAR2(50 CHAR),
STATUS_CODE VARCHAR2(50 CHAR),
QUANTITY_AMOUNT VARCHAR2(50 CHAR)
);

Type TP_LINE_P133_13301_RENGAS_WS compiled

Elapsed: 00:00:00.076
SQL> SHOW ERRORS;

Errors for PACKAGE BODY TDMI_STA.PKG_P133_13303_RENGAS_WS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
341/3 PL/SQL: SQL Statement ignored
356/31 PLS-00302: component 'GET_LOV_REN_GAS_CUI_ID_BY_CUI' must be declared
358/31 PLS-00302: component 'GET_LOV_REN_GAS_CUI_ID_BY_EIC' must be declared
371/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
375/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
377/13 PL/SQL: ORA-00904: "PKG_UTILS"."GET_LOV_REN_GAS_EGAS_COD_DEF":
identificador inválido
377/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
377/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
SQL>
SQL> CREATE OR REPLACE EDITIONABLE TYPE &var1.TP_TAB_P133_13301_RENGAS_WS AS TABLE
OF TP_LINE_P133_13301_RENGAS_WS;
2 /
old:CREATE OR REPLACE EDITIONABLE TYPE &var1.TP_TAB_P133_13301_RENGAS_WS AS TABLE
OF TP_LINE_P133_13301_RENGAS_WS;

new:CREATE OR REPLACE EDITIONABLE TYPE TDMI_STA.TP_TAB_P133_13301_RENGAS_WS AS

TABLE OF TP_LINE_P133_13301_RENGAS_WS;

Type TP_TAB_P133_13301_RENGAS_WS compiled

Elapsed: 00:00:00.035
SQL> SHOW ERRORS;

Errors for PACKAGE BODY TDMI_STA.PKG_P133_13303_RENGAS_WS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
341/3 PL/SQL: SQL Statement ignored
356/31 PLS-00302: component 'GET_LOV_REN_GAS_CUI_ID_BY_CUI' must be declared
358/31 PLS-00302: component 'GET_LOV_REN_GAS_CUI_ID_BY_EIC' must be declared
371/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
375/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
377/13 PL/SQL: ORA-00904: "PKG_UTILS"."GET_LOV_REN_GAS_EGAS_COD_DEF":
identificador inválido
377/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
377/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
SQL>
SQL> --------------------------------------------------------
SQL> -- DDL FOR TABLE DT_STG_P133_13301_RENGAS_WS
SQL> --------------------------------------------------------
SQL> BEGIN
2 EXECUTE IMMEDIATE 'DROP TABLE TDMI_STA.DT_STG_P133_13301_RENGAS_WS FORCE';
3 EXCEPTION
4 WHEN OTHERS THEN
5 IF SQLCODE != -942 THEN
6 RAISE;
7 END IF;
8 END;
9 /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.014
SQL>
SQL> CREATE TABLE &var1."DT_STG_P133_13301_RENGAS_WS"
2 ( ID_EXEC NUMBER NOT NULL,
3 ID_EXEC_SOURCE NUMBER NOT NULL,
4 IDENTIFICATION VARCHAR2(50 CHAR),
5 VERSION VARCHAR2(50 CHAR),
6 "TYPE" VARCHAR2(50 CHAR),
7 CREATION_DATETIME VARCHAR2(50 CHAR),
8 CONTRACT_REF VARCHAR2(50 CHAR),
9 ISSUER_ID VARCHAR2(50 CHAR),
10 ISSUER_MARKET_CODE VARCHAR2(50 CHAR),
11 RECIPIENT_ID VARCHAR2(50 CHAR),
12 RECIPIENT_MARKET_CODE VARCHAR2(50 CHAR),
13 APPLICATION_CTX VARCHAR2(50 CHAR),
14 METER_ID VARCHAR2(50 CHAR),
15 MEASURE_UNIT_CODE VARCHAR2(50 CHAR),
16 TIME_INTERVAL VARCHAR2(50 CHAR),
17 DATE_UTC VARCHAR2(50 CHAR),
18 DIRECTION_CODE VARCHAR2(50 CHAR),
19 STATUS_CODE VARCHAR2(50 CHAR),
20 QUANTITY_AMOUNT VARCHAR2(50 CHAR),
21 STG_LOAD_INDICATOR NUMBER NOT NULL,
22 ODS_LOAD_INDICATOR NUMBER NOT NULL,
23 HIST_LOAD_INDICATOR NUMBER NOT NULL,
24 MFK NUMBER NOT NULL,
25 CREATED_BY NUMBER,
26 CREATED_ON TIMESTAMP (6),
27 CREATED_PROCESS NUMBER,
28 UPDATED_BY NUMBER,
29 UPDATED_ON TIMESTAMP (6),
30 UPDATED_PROCESS NUMBER
31 ) TABLESPACE "TDMI_STA_DATA";
old:CREATE TABLE &var1."DT_STG_P133_13301_RENGAS_WS"
( ID_EXEC NUMBER NOT NULL,
ID_EXEC_SOURCE NUMBER NOT NULL,
IDENTIFICATION VARCHAR2(50 CHAR),
VERSION VARCHAR2(50 CHAR),
"TYPE" VARCHAR2(50 CHAR),
CREATION_DATETIME VARCHAR2(50 CHAR),
CONTRACT_REF VARCHAR2(50 CHAR),
ISSUER_ID VARCHAR2(50 CHAR),
ISSUER_MARKET_CODE VARCHAR2(50 CHAR),
RECIPIENT_ID VARCHAR2(50 CHAR),
RECIPIENT_MARKET_CODE VARCHAR2(50 CHAR),
APPLICATION_CTX VARCHAR2(50 CHAR),
METER_ID VARCHAR2(50 CHAR),
MEASURE_UNIT_CODE VARCHAR2(50 CHAR),
TIME_INTERVAL VARCHAR2(50 CHAR),
DATE_UTC VARCHAR2(50 CHAR),
DIRECTION_CODE VARCHAR2(50 CHAR),
STATUS_CODE VARCHAR2(50 CHAR),
QUANTITY_AMOUNT VARCHAR2(50 CHAR),
STG_LOAD_INDICATOR NUMBER NOT NULL,
ODS_LOAD_INDICATOR NUMBER NOT NULL,
HIST_LOAD_INDICATOR NUMBER NOT NULL,
MFK NUMBER NOT NULL,
CREATED_BY NUMBER,
CREATED_ON TIMESTAMP (6),
CREATED_PROCESS NUMBER,
UPDATED_BY NUMBER,
UPDATED_ON TIMESTAMP (6),
UPDATED_PROCESS NUMBER
) TABLESPACE "TDMI_STA_DATA"
new:CREATE TABLE TDMI_STA."DT_STG_P133_13301_RENGAS_WS"
( ID_EXEC NUMBER NOT NULL,
ID_EXEC_SOURCE NUMBER NOT NULL,
IDENTIFICATION VARCHAR2(50 CHAR),
VERSION VARCHAR2(50 CHAR),
"TYPE" VARCHAR2(50 CHAR),
CREATION_DATETIME VARCHAR2(50 CHAR),
CONTRACT_REF VARCHAR2(50 CHAR),
ISSUER_ID VARCHAR2(50 CHAR),
ISSUER_MARKET_CODE VARCHAR2(50 CHAR),
RECIPIENT_ID VARCHAR2(50 CHAR),
RECIPIENT_MARKET_CODE VARCHAR2(50 CHAR),
APPLICATION_CTX VARCHAR2(50 CHAR),
METER_ID VARCHAR2(50 CHAR),
MEASURE_UNIT_CODE VARCHAR2(50 CHAR),
TIME_INTERVAL VARCHAR2(50 CHAR),
DATE_UTC VARCHAR2(50 CHAR),
DIRECTION_CODE VARCHAR2(50 CHAR),
STATUS_CODE VARCHAR2(50 CHAR),
QUANTITY_AMOUNT VARCHAR2(50 CHAR),
STG_LOAD_INDICATOR NUMBER NOT NULL,
ODS_LOAD_INDICATOR NUMBER NOT NULL,
HIST_LOAD_INDICATOR NUMBER NOT NULL,
MFK NUMBER NOT NULL,
CREATED_BY NUMBER,
CREATED_ON TIMESTAMP (6),
CREATED_PROCESS NUMBER,
UPDATED_BY NUMBER,
UPDATED_ON TIMESTAMP (6),
 UPDATED_PROCESS NUMBER
) TABLESPACE "TDMI_STA_DATA"

Table TDMI_STA."DT_STG_P133_13301_RENGAS_WS" created.

Elapsed: 00:00:00.042
SQL>
SQL> GRANT SELECT ON &var1.DT_STG_P133_13301_RENGAS_WS TO "ROLE_TDMI_STA_READ";
old:GRANT SELECT ON &var1.DT_STG_P133_13301_RENGAS_WS TO "ROLE_TDMI_STA_READ"
new:GRANT SELECT ON TDMI_STA.DT_STG_P133_13301_RENGAS_WS TO "ROLE_TDMI_STA_READ"

Grant succeeded.

Elapsed: 00:00:00.010
SQL> GRANT DELETE ON &var1.DT_STG_P133_13301_RENGAS_WS TO
"ROLE_TDMI_STA_READ_WRITE";
old:GRANT DELETE ON &var1.DT_STG_P133_13301_RENGAS_WS TO "ROLE_TDMI_STA_READ_WRITE"
new:GRANT DELETE ON TDMI_STA.DT_STG_P133_13301_RENGAS_WS TO
"ROLE_TDMI_STA_READ_WRITE"

Grant succeeded.

Elapsed: 00:00:00.009
SQL> GRANT INSERT ON &var1.DT_STG_P133_13301_RENGAS_WS TO
"ROLE_TDMI_STA_READ_WRITE";
old:GRANT INSERT ON &var1.DT_STG_P133_13301_RENGAS_WS TO "ROLE_TDMI_STA_READ_WRITE"
new:GRANT INSERT ON TDMI_STA.DT_STG_P133_13301_RENGAS_WS TO
"ROLE_TDMI_STA_READ_WRITE"

Grant succeeded.

Elapsed: 00:00:00.008
SQL> GRANT SELECT ON &var1.DT_STG_P133_13301_RENGAS_WS TO
"ROLE_TDMI_STA_READ_WRITE";
old:GRANT SELECT ON &var1.DT_STG_P133_13301_RENGAS_WS TO "ROLE_TDMI_STA_READ_WRITE"
new:GRANT SELECT ON TDMI_STA.DT_STG_P133_13301_RENGAS_WS TO
"ROLE_TDMI_STA_READ_WRITE"

Grant succeeded.

Elapsed: 00:00:00.014
SQL> GRANT UPDATE ON &var1.DT_STG_P133_13301_RENGAS_WS TO
"ROLE_TDMI_STA_READ_WRITE";
old:GRANT UPDATE ON &var1.DT_STG_P133_13301_RENGAS_WS TO "ROLE_TDMI_STA_READ_WRITE"
new:GRANT UPDATE ON TDMI_STA.DT_STG_P133_13301_RENGAS_WS TO
"ROLE_TDMI_STA_READ_WRITE"

Grant succeeded.

Elapsed: 00:00:00.013
SQL>
SQL> SHOW ERRORS;

Errors for PACKAGE BODY TDMI_STA.PKG_P133_13303_RENGAS_WS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
341/3 PL/SQL: SQL Statement ignored
356/31 PLS-00302: component 'GET_LOV_REN_GAS_CUI_ID_BY_CUI' must be declared
358/31 PLS-00302: component 'GET_LOV_REN_GAS_CUI_ID_BY_EIC' must be declared
371/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
375/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
377/13 PL/SQL: ORA-00904: "PKG_UTILS"."GET_LOV_REN_GAS_EGAS_COD_DEF":
identificador inválido
377/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
377/23 PLS-00302: component 'GET_LOV_REN_GAS_EGAS_COD_DEF' must be declared
SQL>
SQL> spool off;