temp.sql

Oracle PL/SQL procedure generator (second generator type)

set serveroutput on size 1000000 format wrapped
SET VERIFY OFF
DECLARE
   v_dir VARCHAR2(1000) := 'c:\temp';
BEGIN
   PLGdoir.setdrvdir ('test',
      v_dir,
      tab => PLGdoir.c_global,
      sch => PLGdoir.c_global);
      
   PLGdoir.setgendir ('test', 
      tab => PLGdoir.c_global,
      dir => v_dir,
      sch => PLGdoir.c_global);
      
   COMMIT;
END;
/
exec plggen.fortab ('te', 'employee');
exec plggen.dbg
exec plgcgml.genfile ('employee', 'tables.gdr');
exec plgcgml.genfile ('employee', 'te_utpkg.gdr');