Hi,

If you have D2K/ Forms, then, I think you can get what
you want.

i) Open D/2K Form
ii) Connect to database
iii) go to Ojbect Navigator
iv) click "Database Objects"
v) click user(schema) you want
vi) Click Stored Program Unit
it will display all stored procedure name
vii) click your choice. It will display the source code;


You can also get source text from DBA_Source in sql plus
see the example

SQL> select text
2 from dba_source
3 where name='HELLO_JAVA';

TEXT
----------------------------------------
procedure Hello_Java(hl varchar2)
as
language java
name 'Hello.main(java.lang.String[])';



Thanks
P. Soni




[Edited by PSoni on 03-20-2001 at 04:49 AM]