Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

package variable

User_FZ3ZWOct 15 2015 — edited Oct 15 2015

Hi,

Can anybody tell me about package variables.  i have following quesitons

1.  when we should declare variable in package specification

2. when we should declare variable in package body (not inside package procedures or functions).

3. when we should declare variable inside procedures or functions in package.

4. if i  want to use user define exception in whole package.then where should i declare and use this.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2015
Added on Oct 15 2015
7 comments
1,482 views