Home » SQL & PL/SQL » SQL & PL/SQL » ORA 06550 cannot execute procedure (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
icon9.gif  ORA 06550 cannot execute procedure [message #349337] Sat, 20 September 2008 07:28 Go to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
Hi all,

I cannot execute my procedures. it gives me the error message

EXECUTE NORTHI_LOADER_MTRL_BSS_GSR81.'BEGIN_LOADER_TRANSFER_TCH' ;

ORA-06550: line 2, column 32:
PLS-00302: component 'BEGIN_LOADER_TRANSFER_TCH' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

when i remove the schema name NORTHI_LOADER_MTRL_BSS_GSR81 it works but these procedures are owned by this schema. why it gives me this error.

Regards

[Updated on: Sat, 20 September 2008 07:45]

Report message to a moderator

Re: ORA 06550 cannot execute procedure [message #349349 is a reply to message #349337] Sat, 20 September 2008 10:56 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8623
Registered: November 2002
Location: California, USA
Senior Member
Perhaps there is another one in your schema or a synonym. Try selecting from all_objects to see what exists with that name.
Re: ORA 06550 cannot execute procedure [message #349361 is a reply to message #349349] Sat, 20 September 2008 13:24 Go to previous messageGo to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
thank you very very much. I checked all_objects and i saw that there is a table having same name with schema i dropped that table and it works. Thanks alot.
Re: ORA 06550 cannot execute procedure [message #349368 is a reply to message #349361] Sat, 20 September 2008 13:54 Go to previous messageGo to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
i deleted this table it looked me like its working but still it doesnt work why ?
Re: ORA 06550 cannot execute procedure [message #349371 is a reply to message #349368] Sat, 20 September 2008 14:05 Go to previous message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
i forgot to create the procedure so sorry. it works... Very Happy
Previous Topic: Single quote to double quotes - please help
Next Topic: oracle sequence
Goto Forum:
  


Current Time: Sat Dec 03 13:54:16 CST 2016

Total time taken to generate the page: 0.13591 seconds