Re: Are PL/SQL variable values runtime only?

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Wed, 22 Jul 2009 15:15:36 -0500 (CDT)
Message-ID: <cdbd8e91dc856c8070c2714f5e8817f4.squirrel_at_society.servebeer.com>



Hi David,

That IS what I'm looking for! Here's the link for the (very different) 10.1 docs:

http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10807/02_funds.htm#sthref204

Whew! I was just in the wrong section of the manual...

Thanks much!
Rich

> Hi,
>
> Is this what you're after:
>
> Constants and variables are initialized every time a block or
> subprogram is entered. By default, variables are initialized to NULL.
> Whether public or private, constants and variables declared in a
> package spec are initialized only once for each session.
>
> (Taken from the usage notes here: http://download.oracle.com/docs/cd/
> B19306_01/appdev.102/b14261/constantvar_declaration.htm#sthref2587)
>
> Regards
> David Lord

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 22 2009 - 15:15:36 CDT

Original text of this message