PL/SQL

Manipulating PL/PGSQL or PL/SQL Procedures Requires Knowing the Call Specification or Signature

Leave a Comment / PL/PGSQL, PL/SQL / By thg

when dropping, recreating, granting access to a pl/sql procedure the entire call specification (including parameters or parameter data types) is required to insure you are affecting the appropriate procedure – this is also referred to as footprint, and or procedure specification or signature.

Simple PL/SQL to generate a load for Goldengate and others

Leave a Comment / GoldenGate, Oracle, Oracle Database, PL/SQL / By thg

# create the table(s), primary key, sequence, and trigger # the sequence and trigger auto populate the primary key CREATE TABLE dept ( ID NUMBER(10) NOT NULL, DESCRIPTION VARCHAR2(50) NOT NULL); ALTER TABLE dept ADD ( CONSTRAINT dept_pk1 PRIMARY KEY (ID)); CREATE SEQUENCE dept_seq START WITH 1; Trigger definition: CREATE OR REPLACE TRIGGER dept_bir BEFORE INSERT …

Simple PL/SQL to generate a load for Goldengate and others Read More »