Re: How to read a Package Body?

the_dodger_at_wanadoo.es (Dodger) wrote in message news:<af29f6c.0205270745.54b8eeda_at_posting.google.com>...
> Hi.
> I'm writing a Java application which connects to Oracle 9i through
> JDBC. From this aplication, I dinamically write a package of functions
> (I use the "create or replace package" and "create or replace package
> body" sentences), like a package editor.
> Now, I need read the package body created, in order to display it on
> the screen, and edit it. But I don't know how to read the package
> body.

select text
from sys.dba_source
where name = '<Package name>'
  and type = 'PACKAGE BODY'
order by line

>
> Using the enterprise manager console, is esay look at the package
> body; the problem is how to do it in SQL-Sentences (for the JDBC).
>
> Thxs...
>
> -Dodger-
Received on Tue May 28 2002 - 09:42:44 CDT