Global Package Variable Issue
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.
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.
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
Click Here to Expand Forum to Full Width