Creating & Using Package in Current Session
This is a discussion on Creating & Using Package in Current Session within the Oracle Database forums, part of the Database Server Software category; --> If I create a package in my current session, can I start using this package right away without needing ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 08:09 AM
| |||
| |||
 Re: Creating & Using Package in Current Session klabu wrote: > If I create a package in my current session, > can I start using this package right away without needing to re-connect > > -- > 10gR2 Why would you need to reconnect to use a package you created? Once it's created it's available for use to all who have access to it. If you write a C program and compile it into an executable you don't need to log out and log in again to use it, do you? Objects are not like grants. David Fitzjarrell      |
|
02-25-2008, 08:09 AM
| |||
| |||
| Re: Creating & Using Package in Current Session On Oct 27, 2:34 pm, "klabu" <nosuchuser_at_gmail_dot_com> wrote: > If I create a package in my current session, > can I start using this package right away without needing to re-connect > > -- > 10gR2 Duh, create one and execute it to find out! You will discover the answer is yes, you can. HTH -- Mark D Powell -- |
|
02-25-2008, 08:09 AM
| ||||
| ||||
| Re: Creating & Using Package in Current Session "Mark D Powell" > Duh, create one and execute it to find out! > You will discover the answer is yes, you can. > HTH -- Mark D Powell -- thanks I have done that before I was just wondering if there is any "issue" or "side-effects" in doing this. For a long time I have made the habit of disconnect after re-compiling then re-connect only this time I'm wrting this script that need to create the packages & call them right after |
Linear Mode
