DSXchange

Hi All,



I am trying to execute this stored procedure after the load in the close command in the Oracle Enterprise Stage and this is what I see, has someone faced something similar please reply.


Fatal Error: Invalid close command : BEGIN MISSING_SCENARIOS(); END;


Message: ORA-00955: name is already used by an existing object
ORA-06512: at "DDM_OWNER_TEST.MISSING_SCENARIOS", line 6
ORA-06512: at line 1

Hi Suresh Nair

What make your stored????
I was searching in the web and find the next link, may be you try to check this operation in your db..

Run this query in your db client ans review the results:

select object_name, object_type
from user_objects
where object_name='<object name>';

you must to check what table, or other object try to create or modify inside your stored ...

Hi,


Thanks for the reply,

When I use a ODBC connector Stage this close command works fine but the problem is with the Oracle Enterprise Stage.





Thanks

I'm not sure the OE stage supports an 'anonymous block' like that. Perhaps try putting "END;" on a separate line?

You should consider moving it out to another area that does support it - ODBC as mentioned or the actual SP stage. Or script something to run it from the command line after job.

whats there in "DDM_OWNER_TEST.MISSING_SCENARIOS"
specially at line 6