Re: JDBC-help: how to call Oracle8 stored procedure with "rowtype" output parameter?

In article <39398416.2F15A54E_at_ebox.de>,
  Felix von Delius <delius_at_ebox.de> wrote:
> Hi,
>
> I have to call a Oracle8 stored procedure from within JDBC which has
 an
> output parameter of type "sometable%rowtype". Is there a way to access
> this?
>
> -Felix
>
>

You cannot bind any 3/4gl to PLSQL record types (only another plsql routine can accept/send a plsql record type). You can do something like:

declare

   my_rec sometable%rowtype;
begin

   procedure( my_rec );
   ? := my_rec.field1;
   ? := my_rec.field2;
   ...
end;

to interface to a procedure that returns a rowtype. The other option is to use an OBJECT type and jpub to build an interface to it.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.