match / merge

From: Vix <v_fisher21_at_yahoo.com>
Date: 28 Sep 2006 05:45:59 -0700
Message-ID: <1159447559.033807.23600@i3g2000cwc.googlegroups.com>

hello

I am learning owb and got stuck with this one problem.

i have successfully validated and generated map with match / merge. however i am having problems deploying it - everytime i try - i get the following errors:
ANOTHERONE_MM
Create
Warning
ORA-06550: line 1370, column 6:
PL/SQL: Statement ignored
ANOTHERONE_MM
Create
Warning
ORA-06550: line 1372, column 26:
PLS-00222: no function with name 'VIX_TEST_TIME1_4_SURNAME$1' exists in this scope

Having looked into the repository where the package is generated i have found out that the function reported in the error is actually a variable. It is being declared in package body and no references to it exists in package speck.
it is not an external variable - it is created by OWB. Debugging is going well until this varialbe is being applied like a function ?!

I would really appreciate if someone could advise me where i am going or what i am doing wrong here.

Thank you very much for all your help Received on Thu Sep 28 2006 - 07:45:59 CDT