SQLDeveloper Sybase to Oracle Migration error.
I'm getting following errror when tried to migrate the schema from Sybase to Oracle.. Any thoughts??
Running 3.0.04 SQL Developer.
oracle.dbtools.migration.command_line.CMDLineError: Problem executing SQL : CREA
TE OR REPLACE TRIGGER "GENCONNKEYTRIG"
BEFORE INSERT ON stage_serverdetail
FOR EACH ROW
BEGIN
IF :new.project_id is null THEN
:new.project_id := MD_META.get_next_id;
END IF;
IF :new.svrid is null THEN
:new.svrid := MD_META.get_next_id;
END IF;
END GenConnKeyTrig;
at oracle.dbtools.migration.capture.CaptureCmd.executeSQL(CaptureCmd.jav
a:385)
at oracle.dbtools.migration.capture.CaptureCmd.createStagingTables(Captu
reCmd.java:365)
at oracle.dbtools.migration.capture.CaptureCmd.onlineCapture(CaptureCmd.
Running 3.0.04 SQL Developer.
oracle.dbtools.migration.command_line.CMDLineError: Problem executing SQL : CREA
TE OR REPLACE TRIGGER "GENCONNKEYTRIG"
BEFORE INSERT ON stage_serverdetail
FOR EACH ROW
BEGIN
IF :new.project_id is null THEN
:new.project_id := MD_META.get_next_id;
END IF;
IF :new.svrid is null THEN
:new.svrid := MD_META.get_next_id;
END IF;
END GenConnKeyTrig;
at oracle.dbtools.migration.capture.CaptureCmd.executeSQL(CaptureCmd.jav
a:385)
at oracle.dbtools.migration.capture.CaptureCmd.createStagingTables(Captu
reCmd.java:365)
at oracle.dbtools.migration.capture.CaptureCmd.onlineCapture(CaptureCmd.
0