DB Wiki

User Tools

Site Tools

Trace: • usefulscripts • exceptions • postgresqlextensions
sequence12

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
sequence12 [2016/05/29 10:12] – created z0hpvksequence12 [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +==== PL/SQL Code for 12c Database ====
 +
 +This package should be installed as the GGATE user on the 12c Database (Target)\\
 +Before installing you need to create the database link and tables from [[sequenceother|here]]\\
 +\\
 +Function MOL_SEQUENCE_CHECK_LINK contains a database link that may need to be renamed.
 +
 <code>-- 12c Package <code>-- 12c Package
 create or replace package MOL_SEQUENCES create or replace package MOL_SEQUENCES
Line 37: Line 44:
 begin begin
 select last_number into seq_number select last_number into seq_number
-from all_sequences@ggint+from all_sequences@ggandracaa
 where sequence_owner = upper(seq_owner)  where sequence_owner = upper(seq_owner) 
 and sequence_name = upper(seq_name); and sequence_name = upper(seq_name);
Line 75: Line 82:
 vSeqName  varchar2(100); vSeqName  varchar2(100);
 cursor SeqValueInt is cursor SeqValueInt is
-select sequence_name, ValueINT from ggate.mol_gg_sequences@ggint+select sequence_name, ValueINT from ggate.mol_gg_sequences@ggandracaa
 where upper(owner) = upper(sequence_owner); where upper(owner) = upper(sequence_owner);
 BEGIN BEGIN
Line 90: Line 97:
        execute immediate 'select ' || sequence_owner || '.' || vSeqName || '.nextval  from dual' into vSeqValuePoc;        execute immediate 'select ' || sequence_owner || '.' || vSeqName || '.nextval  from dual' into vSeqValuePoc;
        execute immediate 'alter sequence ' || sequence_owner || '.' || vSeqName || ' increment by 2';        execute immediate 'alter sequence ' || sequence_owner || '.' || vSeqName || ' increment by 2';
-       update mol_gg_sequences@ggint set ValuePOC = vSeqValuePoc where sequence_name = vSeqName and owner = sequence_owner;+       update mol_gg_sequences@ggandracaa set ValuePOC = vSeqValuePoc where sequence_name = vSeqName and owner = sequence_owner;
        commit;        commit;
      else      else
-       update mol_gg_sequences@ggint set ValuePOC = vSeqValuePoc where sequence_name = vSeqName and owner = sequence_owner;+       update mol_gg_sequences@ggandracaa set ValuePOC = vSeqValuePoc where sequence_name = vSeqName and owner = sequence_owner;
        commit;        commit;
     end if;     end if;
Line 116: Line 123:
 close SeqName; close SeqName;
 END mol_inc1; END mol_inc1;
- 
 END MOL_SEQUENCES; END MOL_SEQUENCES;
 / /
 </code> </code>
sequence12.1464516757.txt.gz · Last modified: (external edit)