Re: Deploying a java stored procedure using JDeveloper. How do I select the methods that will be a procedure?

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Fri, 7 Sep 2001 15:09:04 +0400
Message-ID: <9na9lb$ccf$1_at_babylon.agtel.net>

In general, only Java class methods that return Java scalar values or classes which are directly convertible to Oracle scalar data types and/or Oracle JDBC datatype classes can be used as stored procedures (functions). For example, java.lang.String is converted to VARCHAR2 type, thus public static String someMethod() may be used as stored function. Consult Oracle Java developer's guide for the list of all data types that may be passed as parameters to Java methods or returned from Java methods and for mappings from Java types and classes to Oracle datatypes.

--

Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com

Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer.

"Don" <dchamber_at_mindspring.com> wrote in message news:069gpt8vhad93t1kg2s7q6lh752commg48_at_4ax.com...
> I have created a java class with a method that I want to make a stored
> function. This method returns a value therefore it is a and function
> not a procedure.
> I'm using JDeveloper and when I try to deploy I am given the option to
> choose which methods should be a stored procedure. I only see methods
> that are static and return void. My method returns a java class.
> The documentation states that methods that are public static are shown
> and my mehod is public static.
> What am I doing wrong?
> Can my return type be a java class?
>
> Thanks,
> Don
>
Received on Fri Sep 07 2001 - 13:09:04 CEST