Help SQL and database Package variables
From: StarFighter <ddukic_at_barok.foi.hr>
Date: Thu, 16 Sep 1999 17:43:57 +0200
Message-ID: <7rr2tp$tp2$1_at_as102.tel.hr>
Date: Thu, 16 Sep 1999 17:43:57 +0200
Message-ID: <7rr2tp$tp2$1_at_as102.tel.hr>
Suppose we have a package like
this
______________________________________
Create Or Replace Package dummy As
-- Variables
x Varchar2(10);
y Number(10,2);
Function fun_dummy Return Boolean;
End dummy;
Create Or Replace Package Body dummy As
Function fun_dummy Return Boolean;
Begin
Return(True);
End fun_dummy;
Begin
dummy.y = 1999.99;
End dummy;
_______________________________________
Then try to assign value to x by
executing in SQL Plus
SQL> exec dummy.x := 'Help me!';
Still, everything works fine!
But now, how to find out value of x or y
just using SQL
Plus?
I tried:
SQL>Select dummy.x From Dual;
ORA-00904: invalid
column name
I tried making procedures which in their
exceptions were raising values of x or y
SQL> exec get_value('X');
ORA-20900:
Help me!
ORA-06512: at "SCOTT.GET_VALUE", line 8
ORA-06512: at line 2
ORA-06512: at "SCOTT.GET_VALUE", line 8
ORA-06512: at line 2
Or:
SQL> exec get_value('Y');
ORA-20900:
1999.99
ORA-06512: at "SCOTT.GET_VALUE", line 8
ORA-06512: at line 2
ORA-06512: at "SCOTT.GET_VALUE", line 8
ORA-06512: at line 2
This works fine,
but suppose we have a hundred of variables in hundred of
packages!!!
PLEASE HELLLLLPPPPP!!
StarFighter
Received on Thu Sep 16 1999 - 17:43:57 CEST