Re: How can i get the source code of a Java Stored Procedure?

joncker_at_sdm.de (Oliver Joncker) wrote in message news:<b2e31f95.0110170208.317c6efd_at_posting.google.com>...
> Hi,
>
> in Oracle 8.1.7 i had uploaded a java class (*.java) containing a java
> stored procedure. The RDBMS stored that as a source schema object.
>
> How can i get back the source of the java class from Oracle?
>
> I have to write a java client who needs that source from the
> database.
>
> Can anybody help me?
>
> Thanks
>
> Oliver

now, it's easy ;-)

select TEXT from USER_SOURCE
  where NAME=<name of the class> and type='JAVA SOURCE' order by LINE Received on Fri Oct 19 2001 - 17:04:44 CEST