search

DDieterich / DTGen

DTGEN Code Generation Tool for Relational Designers (See Wiki Branch)
http://dtgen.org
3 stars 0 forks source link

Allow generated scripts to be run with APEX #23

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What will the enhancement do?

  -) Allow generated scripts to be run with APEX in the target schema.

How is this currently done or handled?

  -) Generated scripts must be downloaded and executed in a SQL*Plus session.
  -) Also, create_flow.sql is too big to upload into SQL scripts in APEX.

What version of the product are you using? On what operating system?

  -) Not Yet Released

Please provide any additional information below.

  -) Use SET_SECURITY_GROUP_ID (and SET_USER) before inserting scripts into APEX_APPLICATION_FILES to place in target schema's sgid.

Original issue reported on code.google.com by Duane.Di...@gmail.com on 27 Apr 2012 at 6:42

GoogleCodeExporter commented 9 years ago 
It is important to consider that the running of the create_flow.sql script will 
be slower in APEX because APEX will attempt to parse the entire script before 
executing it.  Also, the result set from executing the script will be quite 
large.

Original comment by Duane.Di...@gmail.com on 27 Apr 2012 at 7:18