Java Stored Procedure extraction from Oracle database.

Suresh Tri

Hi all,

I am interested in extracting the class or jar files which are stored
as java stored procedures in Oracle. But I want to know if these are
stored as references to external files in Oracle database or directly
inside the database. In case if it is directly stored inside the
database is there any way to extract it?. If I can extract these java
files, can these be used in non Oracle applications?

Please help,
Thanks,
Suresh Tri

Jul 19 '05 #1

Subscribe Reply

11485

Hans Forbrich

Suresh Tri wrote:

Hi all,

I am interested in extracting the class or jar files which are stored
as java stored procedures in Oracle. But I want to know if these are
stored as references to external files in Oracle database or directly
inside the database. In case if it is directly stored inside the
database is there any way to extract it?. If I can extract these java
files, can these be used in non Oracle applications?

The source code for Java Stored Procedures, _when made available_, is stored
in the dictionary. The dictionary views are discussed in detail in the
Oracle Reference manual at http://docs.oracle.com (for Oracle9i R2 the html
version is
http://download-west.oracle.com/docs...a96536/toc.htm)
and you would want to look at

ALL_JAVA_ARGUME NTS
ALL_JAVA_CLASSE S
ALL_JAVA_DERIVA TIONS
ALL_JAVA_FIELDS
ALL_JAVA_IMPLEM ENTS
ALL_JAVA_INNERS
ALL_JAVA_LAYOUT S
ALL_JAVA_METHOD S
ALL_JAVA_NCOMPS
ALL_JAVA_RESOLV ERS
ALL_JAVA_THROWS
ALL_SOURCE (contains the actual source code)

It's much easier to see the source when using the Oracle Enterprise Manager
console.

All of this is discussed in the Java Developer's Guide at
http://download-west.oracle.com/docs...a96656/toc.htm
in CHapters 2 and 7.

If you extract the java 'files' you can use them anywhere assuming you have
all the appropriate class libraries available to the target JVM. Note that
anything other than trivial code will likely call Oracle-supplied (or
proprietary) classes, and those might only be available as compiled java,
compiled to 'C', or wrapped PL/SQL.

/Hans

Jul 19 '05 #2

Suresh Tri

Thank you for the detailed information,

Suresh Tri

Jul 19 '05 #3

Similar topics

4543

PL/SQL or Java for web development

by: digi_newbie | last post by:

I have been tasked to provide the advantages/comparison of using Java over PL/SQL for developing a web application to interact with an Oracle database and am struggling to find any resources on the web which compare the two. Apart from myself the organisation does not have any Java/J2EE developers and only a few who can code PL/SQL. I recently worked on a project developing web pages using PL/SQL and found it a backward step putting...

Java

5073

Java Stored Procedures

by: Hawkeye | last post by:

I am investigating the Java Stored Procedure, first to gain better understanding on what this is, and also if it would be suitable for a new project which will be running on Sun One AS7 (Client is Swing) I have spent about a day reading through many docs, mostly in Oracle site and also the past newsgroup discussions. Still, I am not clear really on who this Java Stored Proc

Oracle Database

2216

[HELP]Using Oracle9i db to call .Net Web Service from Java Stored Procedure

by: aychai | last post by:

Hi all, I am trying to make use Oracle9i db to call an external .Net Web Service from a JAva Stored Procedure. I created the .Net Web Service and use JDeveloper 9.0.3.4Build(1247) to create the Client Stub Java class(ie: serviceClientStub.java). Following the instruction from the article"Calling External Web Service from Java Stored Procedure",

Oracle Database

13586

Create ResultSet "from scratch" in Oracle Java Stored Procedure?

by: Jim Garrison | last post by:

I need to create a ResultSet in an Oracle Java Stored Procedure and return it to a PL/SQL caller. I've done quite a bit of research in Oracle's manuals and on the Web, and have found lots of references to going the other direction (PL/SQL passing/returning REF CURSOR to Java), and Java returning an existing ResultSet (obtained from the databse) as a REF CURSOR to PL/SQL. Neither of these is what I'm looking for. My Java stored...

Oracle Database

22145

Executing an MS SQL stored procedure from a java servlet

by: dinesh prasad | last post by:

I'm trying to use a servlet to process a form, then send that data to an SQL server stored procedure. I'm using the WebLogic 8 App. server. I am able to retrieve database information, so I know my application server can talk to the database. I've determined the failure occurs when the the following statement is executed: cstmt.execute(); (due to the failure of println statements placed afterwards). I get the following error after trying to...

Microsoft SQL Server

6964

Download the JAVA , .NET and SQL Server interview with answers

by: Jobs | last post by:

Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of attending interviews. If you own a company best way to judge if the candidate is worth of it. http://www.questpond.com/InterviewRatingSheet.zip

C# / C Sharp

1859

Can Java Store Procedure increase performance?

by: rxding | last post by:

Hello, Performance reason we need to move some of our code into database. Java Store Procedure is given the first choice. However, while investigating some sample code of Java store procedure, PreparedStatement seems to be a must, such as PreparedStatement pstmt = conn.prepareStatement(sql); ..., pstmt.close() in the end. My question is that if the prepareStatement(sql) is called each time when the Java Store Procedure is called, will...

Oracle Database

587

Java Stored Procedure extraction from Oracle database.

by: Suresh Tri | last post by:

Hi all, I am interested in extracting the class or jar files which are stored as java stored procedures in Oracle. But I want to know if these are stored as references to external files in Oracle database or directly inside the database. In case if it is directly stored inside the database is there any way to extract it?. If I can extract these java files, can these be used in non Oracle applications? Please help,

Oracle Database

8996

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9386

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9333

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9254

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8255

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6799

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4608

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3319

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2791

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP