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.