plgpky.sps

Oracle PL/SQL procedure generator (second generator type)

CREATE OR REPLACE PACKAGE PLGpky &authidopen AUTHID CURRENT_USER &authidclose

/*----------------------------------------------------------------
||                  PL/Vision Professional 
||----------------------------------------------------------------
||    File: plgpky.sps
||  Author: Steven Feuerstein
||
|| This is a part of the PL/Vision Professional Code library.
|| Copyright (C) 1996-99 Quest Software, Inc.
|| All rights reserved.
||
|| For more information, call Quest Software at 1-800-REVEAL4
|| or check out our Web page: www.Quest Software.com
||
-----------------------------------------------------------------*/
IS
   TYPE pky_rectype IS RECORD
      (constraint_name ALL_CONSTRAINTS.CONSTRAINT_NAME%TYPE,
       constraint_type ALL_CONSTRAINTS.CONSTRAINT_TYPE%TYPE,
       position ALL_CONS_COLUMNS.POSITION%TYPE,
       column_id ALL_TAB_COLUMNS.COLUMN_ID%TYPE,
       column_name ALL_CONS_COLUMNS.COLUMN_NAME%TYPE);
   
   TYPE pky_tabtype IS TABLE OF pky_rectype 
      INDEX BY BINARY_INTEGER;
         
   FUNCTION name (tab IN VARCHAR2, sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;
      
   FUNCTION fortab (tab IN VARCHAR2, sch IN VARCHAR2 := NULL)
      RETURN pky_tabtype;

   FUNCTION ispkycol (pkytab IN pky_tabtype, col IN VARCHAR2) RETURN BOOLEAN;

   FUNCTION numcols (tab IN VARCHAR2, sch IN VARCHAR2 := NULL)
      RETURN INTEGER;

END PLGpky;                      
/
rem show errors