Announcement Announcement Module
Collapse
No announcement yet.
Call from java to pl sql procedure with object types & tables as out parameter Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Call from java to pl sql procedure with object types & tables as out parameter

    Hi All,

    I want know how my plsql procedure with objects types & collection as out parameter can be handled in java.

    My object declartion is as follows:

    create or replace type ty_column is table of varchar2(250);

    create or replace type ty_test as object
    (
    descr varchar2(40),
    user_created number(12),
    descr_long ty_column
    );

    create or replace type ty_test_table is table of ty_test;

    My Procedure:

    procedure get_ltr_type (p_column_name in r065908.lookup.column_name%type, p_column_value out ty_test_table)
    is
    v_arr ty_test_table;
    v_clm ty_column:=ty_column();
    begin
    select column_value bulk collect into v_clm from r065908.lookup
    where column_name=p_column_name;

    select ty_test(column_name,user_created,v_clm)
    bulk collect into p_column_value
    from r065908.lookup
    where column_name=p_column_name and column_value='TOPCORP';

    end get_ltr_type;

    Its really urgent.

    Thanks in advance.

    Kavitha
Working...
X