Book a Demo

Author Topic: Missing PL/SQL statements after DB import  (Read 2916 times)

grasmueller

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Missing PL/SQL statements after DB import
« 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

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Missing PL/SQL statements after DB import
« Reply #1 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.
No, you can't have it!