|
|
|
|
|
Re: add fucntion to existing package [message #482491 is a reply to message #482472] |
Fri, 12 November 2010 01:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
From my point of view, there are two problems:
a) the OP doesn't know how to add a function to a package
b) the OP doesn't know how to use TOAD
Apart from other sources, this document describes how to use PL/SQL packages. In this case, package already exists; a new function should probably be added into both package specification and package body.
How to do that? In Schema Browser, go to "Packages". Find the package you are interested in. Double click it. A new, "Editor" window will open. It has two tabs: one for package specification, one for package body. Modify both of them. Then compile (using the "Execute as script" icon in the toolbar, or by pressing the F9 button) - specification first, body next. Both must be compiled without errors.
Right; a similar answer has already been provided (it took a lot of time to compose this message as I was doing something else in the meantime). However, I guess it won't do any harm if I post it.
|
|
|
|
|
|