OraFAQ Forum: JDeveloper, Java & XML » how to call java from stored procedure?

Home » Developer & Programmer » JDeveloper, Java & XML » how to call java from stored procedure? (10g on windows 2003 server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to call java from stored procedure? [message #332398]

Tue, 08 July 2008 07:56

kang
Messages: 89
Registered: November 2007

Member

how to call java from stored procedure?
and where the java program(.class) should be located?
say InsertData.java.

class InsertData{
public static void main(String[] args){
// some insert jobs
}
}

Report message to a moderator

Re: how to call java from stored procedure? [message #332405 is a reply to message #332398]

Tue, 08 July 2008 08:11

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

CREATE JAVA and follow the links.

Regards
Michel

Report message to a moderator

Re: how to call java from stored procedure? [message #338061 is a reply to message #332398]

Sat, 02 August 2008 21:40

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

Michel, correct me here if I get it wrong please.

If I remember correctly, to call java from plsql, you don't.

What you do is create a plsql specification that maps to the java procedure. This effectively renames the java procedure and makes it look like a plsql procedure. then you call the plsql specification.

Do a google for this stuff, that is how I learned it. For example, I found this in three seconds...

9.8 Publishing and Using Java in PL/SQL

 standalone function calling a method:

CREATE OR REPLACE FUNCTION fDelete (
   file IN VARCHAR2) 
   RETURN NUMBER
AS LANGUAGE JAVA
   NAME 'JDelete.delete (
            java.lang.String) 
            return int';

Good luck, Kevin

Report message to a moderator

Re: how to call java from stored procedure? [message #338073 is a reply to message #338061]

Sun, 03 August 2008 01:56

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

If I remember correctly, to call java from plsql, you don't.

What you do is create a plsql specification that maps to the java procedure.

You are perfectly right.
I did it short posting the link to the create java section as it itself points to the relevant documentation, among them Database Java Developer's Guide, Chapter 3 Calling Java Methods in Oracle Database

Regards
Michel

Report message to a moderator

Re: how to call java from stored procedure? [message #338128 is a reply to message #338073]

Sun, 03 August 2008 21:58

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

Thanks for the confirm. Kevin

Report message to a moderator

Previous Topic:	inserting xml file into oracle database table
Next Topic:	java.lang.incombatible class change error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 00:58:33 CDT 2023