Home » SQL & PL/SQL » SQL & PL/SQL » How call java parameters from PL/SQL procedure
How call java parameters from PL/SQL procedure [message #304289] Tue, 04 March 2008 14:14 Go to next message
virgos
Messages: 10
Registered: March 2008
Junior Member
Hi all.

I don't know how call java program with more than one parameter from procedure PL/SQL.

For example:
I have procedure:

PROCEDURE main(Param1 VARCHAR2)
AS
LANGUAGE java
NAME 'morfologik.tools.LametyzatorTool.main(java.lang.String[])';

end;
/

and i call for that:lematyzator.main(PARAM1 =>'arg1'); It's ok!
("lematyzator" is name a package)

But how call for example two parameters ??

Help me please.
Sorry for my english.
Re: How call java parameters from PL/SQL procedure [message #304290 is a reply to message #304289] Tue, 04 March 2008 14:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just add ',' and a second parameter.

Regards
Michel
Re: How call java parameters from PL/SQL procedure [message #304292 is a reply to message #304290] Tue, 04 March 2008 15:10 Go to previous messageGo to next message
virgos
Messages: 10
Registered: March 2008
Junior Member
if I call like that:
lematyzator.main(PARAM1 =>'tab_szukane_www,1');

It compile ok but doesn't work in practice.

If I manually start this program from eclipse it's all right.
Re: How call java parameters from PL/SQL procedure [message #304341 is a reply to message #304292] Tue, 04 March 2008 23:31 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
you did not add a second parameter, you changed the contents of your single parameter.
Re: How call java parameters from PL/SQL procedure [message #304456 is a reply to message #304289] Wed, 05 March 2008 05:14 Go to previous messageGo to next message
virgos
Messages: 10
Registered: March 2008
Junior Member
So how do it? Please some example. THX
Re: How call java parameters from PL/SQL procedure [message #304476 is a reply to message #304456] Wed, 05 March 2008 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In the same way you have 1 parameter PARAM1 you add a second one PARAM2.
What is your problem?

Regards
Michel
Re: How call java parameters from PL/SQL procedure [message #304487 is a reply to message #304289] Wed, 05 March 2008 06:41 Go to previous message
virgos
Messages: 10
Registered: March 2008
Junior Member
Thx very much. It's working.
Previous Topic: loading data into table from csv file with spaces between data
Next Topic: dbms_job.submit error
Goto Forum:
  


Current Time: Thu Nov 14 04:15:09 CST 2024