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 global variable not accessible in another package

HeisonlineAug 12 2020 — edited Aug 12 2020

Dear Colleagues ,

I have defined variable in package specification .

Package specification [pkg_old]  :

G_val number;

in package body:

G_val := 10 ;

Now this variable i am trying to use in another package for processing

Pack_new body

G_Num := pkg_old.G_val ;

But somehow I am not able to get the value of G_Val variable in this package ,indeed values being assigned and new package called at same session .

Do you know what I am missing or something else to be checked from database level or DBA level.

Appreciate your help .

Thank you

Comments
Post Details
Added on Aug 12 2020
3 comments
2,034 views