Re: package variable
From: <rtproffitt_at_my-deja.com>
Date: Mon, 27 Mar 2000 17:44:56 GMT
Message-ID: <8bo6lt$eli$1_at_nnrp1.deja.com>
Date: Mon, 27 Mar 2000 17:44:56 GMT
Message-ID: <8bo6lt$eli$1_at_nnrp1.deja.com>
Boris,
Here are some ideas...
- Change the package so that the variable you want is declared to be public...Then....
Select .xxxxxxx Where Column=MyPkg.Variable;
2. Put your select inside a PL/SQL block and call the function once...
Cursor C (tempvar varchar2) is
select
xxxxxx where column = tempvar;
holdFuncval varchar2(xxx);
begin
HoldFuncVal = MyPkg.FunctionX;
For i in C(HoldFuncVal) loop
etc etc etc
End Loop;
Good Luck,
Robert Proffitt
Beckman Coulter
RTProffitt AT beckman DOT com
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Mar 27 2000 - 19:44:56 CEST