Re: PL/SQL procedures and Packages

From: Patrick Flahan <flahan_at_southeast.net>
Date: 1998/01/05
Message-ID: <68sbt1$cp4_at_news.southeast.net>#1/1

If I understand your question correctly, (having variable persist between calls to a stored procedure?) then the only way that I know of is to create a package. In the specification (or body for private variables) for that package define any variables that you want their values to be available between calls to the package. I don' think there is a way to do it with a regular procedure, but I might be wrong.

Patrick Flahan
flahan_at_southeast.com

Amoda Kulkarni wrote in article <34AEFFB7.6FCB_at_bellsouth.net>...

>Hi All,
> How do I make PL/SQL procedures and packages stay in memory?
>
>Thanks in Advance
>Amod
Received on Mon Jan 05 1998 - 00:00:00 CET

This message: [ Message body ]
Next message: Hank Griffioen: "HELP .... Please answer a simple question ... is it possible to call pl/sql from the oracle JDBCthin client ? (coredump)"
Previous message: Jurij Modic: "Re: PL/SQL procedures and packages"
In reply to: Amoda Kulkarni: "PL/SQL procedures and Packages"
In reply to Amoda Kulkarni: "PL/SQL procedures and Packages"
Next in thread: Jonathan and Leonora Samuel: "Re: DEV2000 2.0 on NT CRASH"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message