In article <15071bed.0203270911.141aa974_at_posting.google.com>,
kboyanov_at_printrak.com says...
>
>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
- you have to have at least ONE static method, that is a requirement. This
static method is what you can bind to from SQL. You need a java instantiated
object in order to "start" - just like "main" in a standalong java app.
- so, lets see the java method specification you are binding to and the sql
binding wrapper you have.... without the code, it is very hard to say.
--
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
Received on Wed Mar 27 2002 - 11:47:01 CST
