Re: Are PL/SQL variable values runtime only?

From: Rich Jesse <>
Date: Wed, 22 Jul 2009 15:15:36 -0500 (CDT)
Message-ID: <>

Hi David,

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

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

Thanks much!

> 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:
> B19306_01/appdev.102/b14261/constantvar_declaration.htm#sthref2587)
> Regards
> David Lord

Received on Wed Jul 22 2009 - 15:15:36 CDT

Original text of this message