Re: Executing Java Stored Procedure

dkniveton71_at_msn.com (casper44) wrote in news:be3be537.0203100717.2b62a0a5_at_posting.google.com:

> 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.

From sqlplus you could type:
exec test_load('s1param','s2param','s3param')

-- 
Ken Denny
http://www.kendenny.com/

I was once sad because I had no shoes, until I met a man who had no feet.  
So I took his shoes. I mean he didn't exactly need them, did he?