Re: Pkg Body variables

Package is initialized when user first time access it on the session level. Think about it like each session has a copy of package. Does not matter which user access it.

Alexandre
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, June 03, 2002 11:28 AM

> Hi,
> I am calling a packaged function in sql loader control file.
> I 've declared a variable in pkg body to hold old value . I am comparing
> this with current value obtained from sql ldr
> and also storing last value in the old value variable.
>
> My question is will the package variable declared above retain its value
> after each run of sqlldr.
> if yes then how to reset this value before the next run.
>
> Note : userid remains same for each sqlldr run.
>
>
> Thanks
> Manoj.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexandre Gorbatchev
  INET: alexandre.gorbatchev_at_avermann.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).