-
Global Package Variable Issue
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|