| srihari |
Posted: May 02, 2007 02:25:09 AM |
Total Post: 14
Joined: Mar, 2006
|
I have a doubt regarding the default package of User written stored procedures.
Assume that, I will just login with a user who is having privileges to create procedures.
I will just write a procedure and the procedure compiled successfully.
My doubt is : where will that procedure get stored in the DB Server or in which package does a procedure gets stored ?
Will that get stored in some default package if we don't explicitly store that in a package ?
|
|
|
Srimayee |
| Posted: May 09, 2007 01:27:03 AM | |
|
Total Post: 7
Joined: Dec, 2005
|
Hi,
All procedures that are created are not necessarily part of some package. You may have any number of standalone procedures in your database. Hence there is no default package that is assigned to a standalone procedure.
Other members, please correct me if I am worng.
Regards,
Srimayee.
|
|
|
|
|
srihari |
| Posted: May 09, 2007 01:30:52 AM | |
|
Total Post: 14
Joined: Mar, 2006
|
Many many thanks srimayee. i got what you told.
|
|
|
|
|
Bubun |
| Posted: Jul 09, 2007 04:01:38 AM | |
|
Total Post: 4
Joined: Jul, 2007
|
Yes you r right Mr. Srimayee.
Subhra
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |