| Toad adding the schema name in fron of the procedure name [message #267069] |
Wed, 12 September 2007 07:26  |
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 #267082 is a reply to message #267069] |
Wed, 12 September 2007 08:00  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
