Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Executing Java Stored Procedure
Thomas Kyte <tkyte_at_oracle.com> wrote in message news:<a6h1v602tkd_at_drn.newsguy.com>...
> In article <be3be537.0203100717.2b62a0a5_at_posting.google.com>,
> dkniveton71_at_msn.com says...
> >
> >If a Java Stored Procedure was published to the database using the
> >following definition how would I execute it?
> >
> >CREATE or replace Procedure test_load (s1 varchar2, s2 varchar2, s3
> >varchar2)
> >AS LANGUAGE JAVA
> >NAME 'data_ldr.run_it(java.lang.String[])';
> >
> >Thanks.
>
> trick question. you wouldn't.
>
> you have three INPUTS that are scalar varchar2 IN types in the SQL part of the
> wrapper.
>
> You have on IN/OUT parameter mapped for a scalar varchar2 in the java portion.
>
> Your java call that maps to this SQL wrapper should have 3 inputs, each of which
> are java.lang.String types.
Thanks to both of you for your responses, I makes perfect sense now. Received on Sun Mar 17 2002 - 07:00:55 CST