Re: How to get the code of the stored procedure/package?

From: Grace Tsai <gtsai_at_ribm00.rhic.bnl.gov>
Date: 1997/12/15
Message-ID: <34958695.794B@ribm00.rhic.bnl.gov>#1/1

OK, all the source codes of procedures and packages are in table "all_source", use the SPOOL <filename>, select ..., SPOOL OFF to get the code.

Grace Tsai wrote:
>
> Does anybody know how to get the code of the stored procedure/package?
> I lost some of the files of procedures and packages, but I installed
> them in sqlplus before I lost them. How to get the codes? Any help would
> be greatly appreciated. Thanks in advance.
>
> Grace Tsai
> Brookhaven National Lab
Received on Mon Dec 15 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: phil chang: "Re: How to get the code of the stored procedure/package?"
Previous message: Grace Tsai: "How to get the code of the stored procedure/package?"
In reply to: Grace Tsai: "How to get the code of the stored procedure/package?"
Next in thread: phil chang: "Re: How to get the code of the stored procedure/package?"

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

Original text of this message

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