RE: Get Java from database?

2001-02-16 Thread Vadim Gorbounov
Hi, Paul No Oracle supported tool, as far as I understand. You may try to get content of CREATE$JAVA$LOB$TABLE, field LOB. This supposed to be java binary. This table could be found in the same schema, where do you have Java classes. You may need to write a small client code (Java, C, PL/SQL). Nev

RE: Get Java from database?

2001-02-16 Thread Paul Baumgartel
What about a binary (i.e., class) file? Any way to extract it to an OS file? I'm asking because we have some Java stored procedures of uncertain origin and we're trying to locate the source. They're stored in the DB as classes. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x10

RE: Get Java from database?

2001-02-15 Thread Vadim Gorbounov
Something like select text from dba_source (or user_source) where owner = .. and dbms_java.longname(name) = .. and type = 'JAVA SOURCE' should help. Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, February 15, 2001 4:42 PM To: Multiple recipients of list ORACLE-L No,

RE: Get Java from database?

2001-02-15 Thread Paul Baumgartel
No, I wasn't clear enough; I mean retrieve into a file. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Thursday, February 15, 2001 4:16 PM To: Multiple recipients of list ORACLE-L You mean, drop? drop

RE: Get Java from database?

2001-02-15 Thread Vadim Gorbounov
You mean, drop? dropjava. -Original Message- Sent: Thursday, February 15, 2001 3:02 PM To: Multiple recipients of list ORACLE-L I'm new to Java in the DB. Once a class or source has been loaded into Oracle, is there any way to get it back out? Thanks. Paul Baumgartel InstiPro, Inc.