Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: grasmueller on July 30, 2009, 01:31:26 am

Title: Missing PL/SQL statements after DB import
Post by: grasmueller on July 30, 2009, 01:31:26 am

Hi,

after importing a schema from an oracle database in all views and triggers are imported without the full SQL. The Views are imported as e.g.
CREATE OR REPLACE VIEW "PERSONEN"
AS
s
and after the "s" of the select the rest is missing. The other views are similar.
The triggers look like (in the "Behavior" tab, Field "Initial Code")
CREATE OR REPLACE TRIGGER TEST
AFTER INSERT OR UPDATE
ON XYZ
FOR EACH ROW
D
/
Is there a possibility to get the full SQL defining the triggers/views?

Thanks in advance,
 Andreas

Title: Re: Missing PL/SQL statements after DB import
Post by: «Midnight» on July 30, 2009, 02:08:30 am

That sounds like a bug. Obviously EA has established some valid connection to the SQL code, but is truncating it.

First make sure you have the most recent EA build (846 at this writing). Check the release notes if you cannot upgrade.

If the problem persists I suggest you file a bug report with Sparx. Use the Report a Bug link near the bottom of any forum page.