Global Package Variable Issue

[Tarus]

Hi All,

I declared one global package variable a=10 inside Package spec.

Iam able to access these variable when used inside PLSQL Block.

when i try to access in the sql prompt iam getting error.


example :-

SQL>Select 1234+a from dual;

Is there any way to use the globally declared variable from sql promt.

Kindly help me to resolve this issue.

Thanks!

Regards,
Tarus

[davey23uk]

you haven't defined a anywhere, you can only reference a in your package as that is where you have defined it, there is no such thing as a globally declared variable for the database