Java stored procedures

[ETLMaster]

Hi there,
I was hoping someone could comment on the performance of Java in the database. I don't intend to do anything fancy. All I want to do is do something like

insert into t
select c1,format(c1),c2,format(c2) from t1;

where format is a static Java method wrapped in some call spec. So I'm hoping it should perform fine, but any real, empirical evidence would be great.

Any help is appreciated.

Ron

 

[sem]

For such kind of procedures pl/sql works MUCH faster.

Regards, Dima