Re: FTP from within PL/SQL using Java stored procedure

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 27 Mar 2002 17:17:21 GMT
Message-ID: <3CA1FEA3.7B48F183@exesolutions.com>

Why aren't you using the Oracle built-in package to do this? Why re-invent the wheel?

Daniel Morgan

Krassimir Boyanov wrote:

> Hi,
>
> I am using Oracle 8i.
> I want to use my FTPClient Java class from within Pl/SQL.
> I have tested Java class from Java itself, it works fine.
> NOTE: I want to instanciate the methods, not make them static.
>
> I created PL/SQL object wrapping the method for connect(server, user, pass),
> and then call this method from within anonymous PL/SQL block.
>
> The result is getting error:
> "ORA-00932:Incosistent Datatypes"
>
> Any suggestions.
> Many TIA.
>
> Krassimir
Received on Wed Mar 27 2002 - 11:17:21 CST