search

DDieterich / DTGen

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

Can't Generate New Files in DTGen GUI #92

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

 1. Fresh Load of DTGen
 2. Generate Files
 3. Generate Fails with ORA-20004: file_lines_tab.check_rec(): file_id cannot be null.

What is the expected output? What do you see instead?

 -) Should generate successfully.

Please use labels and text to provide additional information.

 -) "returning id into n_id" is missing from the insert SQL in FILES_VIEWS.ins

Original issue reported on code.google.com by Duane.Di...@gmail.com on 5 Oct 2012 at 9:54

GoogleCodeExporter commented 9 years ago 
An alternative to "returning id into n_id" would be
  "n_id := FILES_DML.get_id(natural keys)"

Original comment by Duane.Di...@gmail.com on 5 Oct 2012 at 10:07

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Corrected Solution: A complete re-query of the base table is performed by the 
view package when db_constraints is TRUE.  Unit test coverage was also updated.

Original comment by Duane.Di...@gmail.com on 8 Oct 2012 at 5:12

GoogleCodeExporter commented 9 years ago 
The glob.db_constraints test and the complete re-query need to be moved to the 
_DML package because the results of the re-query are abandoned by the view 
trigger.

Original comment by Duane.Di...@gmail.com on 22 Oct 2012 at 9:00