plgdoir.sps

Oracle PL/SQL procedure generator (second generator type)

      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN BOOLEAN;

   /* Allow primary key updates */
   PROCEDURE setupdpky
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE nosetupdpky
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION updpky
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN BOOLEAN;

/* Count Rows function option */
   PROCEDURE setcountrows
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE nosetcountrows
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION usecountrows
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN BOOLEAN;

/* Include restrict references pragma? */
   PROCEDURE setrestrictref
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE nosetrestrictref
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION userestrictref
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN BOOLEAN;

   /* Error Handling Approach */
   PROCEDURE setpsexc
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       raisemech IN VARCHAR2 := NULL,
       handlemech IN VARCHAR2 := NULL,
       sch IN VARCHAR2 := NULL);

   PROCEDURE setplvexc
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       raisemech IN VARCHAR2 := NULL,
       handlemech IN VARCHAR2 := NULL,
       setcontext IN BOOLEAN := FALSE,
       sch IN VARCHAR2 := NULL);

PROCEDURE setretcd
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       raisemech IN VARCHAR2 := NULL,
       handlemech IN VARCHAR2 := NULL,
       successval IN VARCHAR2 := 0,
       failureval IN VARCHAR2 := NULL,
       /* = SQLCODE */
       failuremsg IN VARCHAR2 := NULL,
       /* = SQLERRM */
       sch IN VARCHAR2 := NULL);

   PROCEDURE usexmn
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE nousexmn
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   /* View-related */
   PROCEDURE settabforview
      (drv IN VARCHAR2,
       vu IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION tabforview
      (drv IN VARCHAR2,
       vu IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   /* Column-level information */
   PROCEDURE hidecol
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       col IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE nohidecol
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       col IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE updatecol
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       col IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE noupdatecol
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       col IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE setcompany
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       company IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   /* Enable SELECT FOR UPDATE option */

   PROCEDURE setsfu
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sfucols IN VARCHAR2 := 'FOR UPDATE',
       dontwait IN BOOLEAN := FALSE,
       sch IN VARCHAR2 := NULL);

   FUNCTION sfu
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   /* Set object abbreviation. */
   PROCEDURE setobjabbrev
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       abbrev IN VARCHAR2,
       sch IN VARCHAR2 := NULL,
       always_use IN BOOLEAN := FALSE);

   FUNCTION objabbrev
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   PROCEDURE useobjabbrev
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE nouseobjabbrev
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION using_objabbrev
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
       RETURN BOOLEAN;

   /* Cursor definitions */
   TYPE curinfo_rt IS RECORD (
       drv PLGadmin.identifier,
       curname PLGadmin.identifier,
       collist PLGadmin.dbmaxvc2,
       from_clause PLGadmin.dbmaxvc2,
       where_clause PLGadmin.dbmaxvc2,
       group_by_clause PLGadmin.dbmaxvc2,
       order_by_clause PLGadmin.dbmaxvc2,
       objid INTEGER
      );

   TYPE curinfo_tabtype IS TABLE OF curinfo_rt
      INDEX BY BINARY_INTEGER;

   PROCEDURE setcurinfo
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       cur IN VARCHAR2,
       collist IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION curinfo
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN curinfo_tabtype;

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

   /* Aliases */

   /*NOT USED
   PROCEDURE clear_aliases
      (drv IN VARCHAR2);
   */

   PROCEDURE setalias
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2,
       aliastype IN VARCHAR2,
       ident_query IN VARCHAR2,
       ident_list IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE setalias
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE set_global_alias
      (drv IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2 := NULL,
       aliastype IN VARCHAR2 := NULL,
       ident_query IN VARCHAR2 := NULL,
       ident_list IN VARCHAR2 := NULL);

   PROCEDURE set_cust_alias
      (drv IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2 := NULL);

   PROCEDURE set_ident
      (drv IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2 := NULL);

   PROCEDURE set_tag
      (drv IN VARCHAR2,
       tag IN VARCHAR2,
       xmpl IN VARCHAR2 := NULL,
       descrip IN VARCHAR2 := NULL,
	  otag IN VARCHAR2 := NULL,
	  ctag IN VARCHAR2 := NULL);

   FUNCTION is_tag
      (drv IN VARCHAR2,
       nm IN VARCHAR2,
	  otag IN VARCHAR2 := NULL,
	  ctag IN VARCHAR2 := NULL)
       RETURN BOOLEAN;

   FUNCTION tag_descrip
      (drv IN VARCHAR2,
       nm IN VARCHAR2,
	  otag IN VARCHAR2 := NULL,
	  ctag IN VARCHAR2 := NULL)
       RETURN VARCHAR2;

   FUNCTION tag_example (drv IN VARCHAR2, nm IN VARCHAR2,
	  otag IN VARCHAR2 := NULL,
	  ctag IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   PROCEDURE set_colident
      (drv IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2 := NULL,
       override IN VARCHAR2 := NULL);

   PROCEDURE set_objident
      (drv IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2 := NULL,
       override IN VARCHAR2 := NULL);

   PROCEDURE set_indident
      (drv IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2 := NULL,
       override IN VARCHAR2 := NULL);

   PROCEDURE set_consident
      (drv IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2 := NULL);

   PROCEDURE set_fkyident
      (drv IN VARCHAR2,
       orig IN VARCHAR2,
       subst IN VARCHAR2,
       descrip IN VARCHAR2 := NULL,
       override IN VARCHAR2 := NULL);

   PROCEDURE set_wrap_alias
      (drv IN VARCHAR2,
       name IN VARCHAR2,
       prefix IN VARCHAR2,
       suffix IN VARCHAR2,
       descrip IN VARCHAR2 := NULL);

   PROCEDURE set_wrap_alias
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       name IN VARCHAR2,
       prefix IN VARCHAR2,
       suffix IN VARCHAR2,
       sch IN VARCHAR2);

   PROCEDURE setprefix
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       name IN VARCHAR2,
       prefix IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   PROCEDURE setsuffix
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       name IN VARCHAR2,
       suffix IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION alias
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       aliastype IN VARCHAR2,
       sch IN VARCHAR2)
      RETURN VARCHAR2;

   FUNCTION alias
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   PROCEDURE get_wrap_alias
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       name IN VARCHAR2,
       prefix OUT VARCHAR2,
       suffix OUT VARCHAR2,
       descrip OUT VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION alias_prefix
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   FUNCTION alias_suffix
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   FUNCTION alias_descrip
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   FUNCTION alias_context
      (drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       aliastype IN VARCHAR2 := NULL,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;

   FUNCTION global_object (str IN VARCHAR2) RETURN BOOLEAN;

   FUNCTION global_object (
       drv IN VARCHAR2,
       tab IN VARCHAR2,
       orig IN VARCHAR2,
       aliastype IN VARCHAR2 := NULL,
       sch IN VARCHAR2 := NULL)
      RETURN BOOLEAN;

   /* NOT USED Driver identifiers
   PROCEDURE setidentifier
      (drv IN VARCHAR2,
       ident IN VARCHAR2,
       descrip IN VARCHAR2);

   FUNCTION numidentifiers
      (drv IN VARCHAR2,
       sch IN VARCHAR2 := NULL)
      RETURN INTEGER;

   PROCEDURE loadidentifiers
      (drv IN VARCHAR2,
       sch IN VARCHAR2 := NULL);

   FUNCTION identifier
      (drv IN VARCHAR2,
       pos IN INTEGER := NULL,
       sch IN VARCHAR2 := NULL)
      RETURN VARCHAR2;
   */

   /* Driver Structure Information */
   FUNCTION driver_wide_src
      (drv IN VARCHAR2,
       srctype IN VARCHAR2)
      RETURN BOOLEAN;

   FUNCTION column_specific_src
      (drv IN VARCHAR2,
       srctype IN VARCHAR2)
      RETURN BOOLEAN;