Home » SQL & PL/SQL » Client Tools » Toad adding the schema name in fron of the procedure name
Toad adding the schema name in fron of the procedure name [message #267069] Wed, 12 September 2007 07:26 Go to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Good Morning all.

I have Toad 9.0.1 and when I executed my procedure it always adds my schema name infront of my procedure name.
For example, I have a procedure:

CREATE OR REPLACE PROCEDURE employees AS

after executed it became:

CREATE OR REPLACE PROCEDURE TRAN001.employees AS

Does anyway to execute my procedure without the schema name is added automatically?
Your answer is appreciated.
Re: Toad adding the schema name in fron of the procedure name [message #267071 is a reply to message #267069] Wed, 12 September 2007 07:32 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
In what context ? If you select the "create script" option, there is generally a checkbox to include or not include the schema name.
Re: Toad adding the schema name in fron of the procedure name [message #267077 is a reply to message #267071] Wed, 12 September 2007 07:53 Go to previous messageGo to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Hi.

thanks much. but could you please to tell me more where to get the 'create script' option? I could not find it anywhere.

Thanks
Re: Toad adding the schema name in fron of the procedure name [message #267082 is a reply to message #267069] Wed, 12 September 2007 08:00 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
It depends what version of TOAD you have. I have 8.6.1, where you can right-click on the package in the schema browser and get an option to generate the script. Also, the schema browser in my version doesn't include the schema name when showing the code for the package.

If all else fails, you could always generate the script yourself by selecting the text from user_source.
Re: Toad adding the schema name in fron of the procedure name [message #267085 is a reply to message #267082] Wed, 12 September 2007 08:05 Go to previous message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
I have Toad 9.0.1. All my friends they have version 8 and don't have that problem
Previous Topic: Oracle SQl Developer Problem....
Next Topic: SQL * PLUS
Goto Forum:
  


Current Time: Fri Dec 09 02:16:11 CST 2016

Total time taken to generate the page: 0.09187 seconds