This discussion is archived
0 Replies Latest reply: Aug 1, 2007 10:19 PM by 591071 RSS

Problem when convert stored procedure From informix DB  9.4 to Oracle 10g

591071 Newbie
Currently Being Moderated
Hello all,
The problem is that OWB doesn't parse global variables correctly.
My datasource db is Informix 9.4 on WinXP OS. And i try to convert it to Oracle 10g on SOLARIS OS.
My procedure has two links to global variables:
......................
define global gv_dflt_langue char (7) default null;
define global gv_dflt_langue_d INT8 default 0;

.....................

But when i create an oracle model my global package GLOBALPKG has only one variable.

CREATE OR REPLACE PACKAGE globalPkg AS
/* This package is used to emulate Informix GLOBAL variables. */
gv_dflt_langue CHAR(7);
END globalPkg;


Is it a known issue? How can i resolve it?
Thanks for any help.