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
Invalid Close Command
Moderators: chulett, rschirm, roy
Invalid Close Command
Knowledge is Collection of Facts and Wisdom is Simplifying those Facts.
Suresh Nair
Suresh Nair
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: Invalid Close Command
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 ...
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 ...
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
Re: Invalid Close Command
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
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
Knowledge is Collection of Facts and Wisdom is Simplifying those Facts.
Suresh Nair
Suresh Nair
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia