how to call the main class inside jar from oracle function

Question

I have one jar in oracle database and i want to call that jar and send some parameters to the main class function

    public getOffer(String name 1,String name2){

    } // function that in main class in jar

how to implement this. Waiting for helpful replies Thanks in advance guys.

Don't just repeat the same question over and over again. Improve the first one insted. http://stackoverflow.com/questions/17021844/sending-parameter-to-main-class-function-in-jar — maba, Jun 10 '13 at 11:39

score 0 · Answer 1 · answered Jun 10 '13 at 11:37

0

import that jar in your program and create object of that class and simple call that method by object.methodname and necessary parameter that methods required

answered Jun 10 '13 at 11:37

shreyansh jogi

2,082
12
20

score 0 · Accepted Answer · answered Jun 10 '13 at 11:44

0

To call a Java method inside the oracle database you have to make this method static (like a main(String[]) method.

After that you have to create a PL/SQL-wrapper:

create or replace function get_offer(name1 in varchar2, name2 in varchar2) return varchar2
is language java name 'MyClass.getOffer(java.lang.String,java.lang.String) return java.lang.String';
/

See also the Oracle Documention.

answered Jun 10 '13 at 11:44

Uwe Plonus

9,803
4
41
48

but main class is in jar and this jar in oracle database. so This wrapper will work ? – SURJA Jun 10 '13 at 11:52
@SURJA I you loaded the jar with `loadjar` it works. – Uwe Plonus Jun 10 '13 at 12:09
Thanks Uwe Plonus , i will try thanks again and please give me some shortcut description or any link about how to load jar using loadjar and please mail me u r email id to [email protected] to make some work deal – SURJA Jun 10 '13 at 12:17
@SURJA Please follow the link to the Oracle documetation I gave in my answer. – Uwe Plonus Jun 10 '13 at 12:18
i read the given oracle documentation but there is no any loadjar , there is a loadjava so will it work if i will use loadjava to load jar file into oracle database – SURJA Jun 13 '13 at 18:14
@SURJA I meant `loadjava`. – Uwe Plonus Jun 14 '13 at 05:51
thanks, if the main jar contains another jar then how i will write the loadjava , i read oracle documentation but i m confused..Thanks in advance – SURJA Jun 14 '13 at 07:22

how to call the main class inside jar from oracle function

2 Answers2