plgvar.sps

Oracle PL/SQL procedure generator (second generator type)

CREATE OR REPLACE PACKAGE PLGvar &authidopen AUTHID CURRENT_USER &authidclose
/*----------------------------------------------------------------
||                  PL/Vision Professional 
||----------------------------------------------------------------
||    File: plvvar.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
   /* Assign values to variables dynamically. */
   
   PROCEDURE assign (expr IN VARCHAR2, var IN OUT BOOLEAN,
      dyncur IN INTEGER := NULL,
      use_plgerr IN BOOLEAN := TRUE);
   PROCEDURE assign (expr IN VARCHAR2, var IN OUT DATE,
      dyncur IN INTEGER := NULL,
      use_plgerr IN BOOLEAN := TRUE);
   PROCEDURE assign (expr IN VARCHAR2, var IN OUT NUMBER,
      dyncur IN INTEGER := NULL,
      use_plgerr IN BOOLEAN := TRUE);
   PROCEDURE assign (expr IN VARCHAR2, var IN OUT VARCHAR2,
      dyncur IN INTEGER := NULL,
      use_plgerr IN BOOLEAN := TRUE);

   PROCEDURE copyto (val IN VARCHAR2, nm IN VARCHAR2,
      dyncur IN INTEGER := NULL,
      showerr IN BOOLEAN := FALSE,
      use_plgerr IN BOOLEAN := TRUE);
END PLGvar;
/
rem show errors