Database Software

Hi,

Well i am not a OWB guy. I am more into Oracle part(OLTP as well as OLAP). I was asked to write a proc that will execute maps(all) once. I worte at as below

DECLARE
  RETVAL    NUMBER;
  P_ENV     WB_RT_MAPAUDIT.WB_RT_NAME_VALUES;
BEGIN
  FOR I IN ( SELECT OBJECT_NAME
             FROM   MIS_OWB_RTREP.ALL_RT_OBJECTS
             WHERE  OBJECT_TYPE='PLSQLMap'
             AND    OBJECT_NAME LIKE 'ANYTHING\_%' ESCAPE '\') LOOP
  RETVAL :=I.OBJECT_NAME.MAIN(P_ENV);
  END LOOP;
  DBMS_OUTPUT.PUT_LINE('RETVAL IS '||RETVAL);
END;

While executing it gives an error as
SQL> /
RETVAL :=I.OBJECT_NAME.MAIN(P_ENV);
*
ERROR at line 9:
ORA-06550: line 9, column 26:
PLS-00487: Invalid reference to variable 'OBJECT_NAME'
ORA-06550: line 9, column 3:
PL/SQL: Statement ignored

where is the problem?

Any ideas?

Regards,
SID