Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: persistent variables?

Re: persistent variables?

From: Chrysalis <cellis_at_iol.ie>
Date: 1997/03/04
Message-ID: <331C4FCA.68E2@iol.ie>#1/1

vvt_at_telerama.lm.com wrote:
>
> We run batch vax cobol programs with embedded pl/sql. The problem we
> are experiencing is that the variables do not retain their values
> between programs even though the programs all appear to run in the
> same session. The sql works fine in SQL+. Any help would be
> appreciated.

  1. Variables declared in an anonymous procedure are *not* persistent between executions.
  2. Variables declared in a package header (not the body) *should* be persistent between executions (and are, in my experience).

Hope this helps.

Chrysalis. Received on Tue Mar 04 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US