Home » Developer & Programmer » Warehouse Builder » Return value 2 while running the OWB Mapping package in SQL
Return value 2 while running the OWB Mapping package in SQL [message #93333] Tue, 20 July 2004 21:53
Lenin Sahoo
Messages: 3
Registered: July 2004
Junior Member
Hi,

When I am executing the OWB mapping package through SQL session, I am getting return value as 2. But the required functionality defined in the mapping is working perfectly fine.

As far as I know, the return value 0 is correct one, and return value 1 indicates there is some error.

So, can you please tell me, for what the return value 2 stands for?

I am running the mapping package by running the follwing wrapper in SQL session:

========

SQL> set serverout on
SQL> DECLARE
  2    RetVal NUMBER;
  3    P_ENV WB_RT_MAPAUDIT.WB_RT_NAME_VALUES;
  4  BEGIN
  5    RetVal := UII_MAP_NCA_DSL_VP.MAIN ( P_ENV );
  6  dbms_output.put_line('Retval is ==> '|| retval);
  7  END;
  8  /
Retval is ==> 2

PL/SQL procedure successfully completed.

==========

Thanks & Regards,
Lenin
Previous Topic: OLAP
Next Topic: oracle express spreadsheet add-in
Goto Forum:
  


Current Time: Fri Aug 01 02:02:46 CDT 2014

Total time taken to generate the page: 0.06858 seconds