Re: Executing Java Stored Procedure

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.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp