Re: Stored Procedures and Result Sets

I'm not sure how helpful this is but... I know that in Visual

  	Basic you can use the logic you describe utilizing VB RDO objects
	(specifically rdo queries and resultsets).

	Maybe there's something similar in JDBC?

	Tracy		tlp_at_redrockgrp.com

Thomas Boyd wrote:

>
> This question is more appropriate for a java/jdbc forum, but I thought
> that the
> more general question of returning result sets from PL/SQL procedures
> might get answered here:I
>
> I am attempting to write JDBC calls to Oracle procedures that include
> Oracle PL/SQL arrays (Oracle actually calls them PL/SQL tables).
>
> The package specification might look like:
>
> create or replace package foo_pkg is
> type num_arr is table of number index by binary_integer;
>
> procedure foo_proc (p_number_array in out num_arr);
> end foo;
>
> Can I call this procedure from JDBC? What datatype/object will be
> passed for
> p_number_array?
>
> This really relates to the problem that we have logic that is too
> complicated
> to embed in a query or a view, and we cannot return a result set from an
>
> Oracle PL/SQL procedure. If we cannot use arrays, does anyone have an
> alternative solution for returning multiple rows from an Oracle
> procedure?
>
> Thanks,
> Tom Boyd
Received on Thu May 14 1998 - 16:27:39 CDT