Procedures are Failing with error DBMS_snapshot

Open kirandba-hub opened this issue 5 years ago • 1 comments

Hi,

When i am creating procedures which migrated from the Oracle using Ora2pg,i am getting below error.

gdsrm_sdm=# \i /etc/ora2pg/GDSRM_SDM_Migration/Procedures/SDM_MAT_VIEW_REFRESH3_GDSRM_SDM_procedure.sql SET psql:/etc/ora2pg/GDSRM_SDM_Migration/Procedures/SDM_MAT_VIEW_REFRESH3_GDSRM_SDM_procedure.sql:24: ERROR: syntax error at or near "DBMS_snapshot" LINE 3: DBMS_snapshot.REFRESH('MV_DIM_EVENT_ATTRIB');

Is there any alternative way in postgres to convert the DBMS_Snapshot.Refresh or any other approach is there to create the procedures like this.

Thanks and Regards, Kiran.

Sep 20 '20 17:09 kirandba-hub

Need to be fixed, for the moment there is no automatic translation of DBMS_Snapshot.Refresh but this is trivial to fix.

Sep 21 '20 12:09 darold