Four Stars

tOracleSP returning a RECORD TYPE

I have a Oracle stored procedure that returns a RECORD type and I am not sure how its configured using tOracleSP.

 

create or replace package testpkg as
    --
    type test_rec is record (
        pid               number,
        pname             varchar2(30)
    );
    --
    procedure main (
        p_id                in varchar2 := null,
        p_admin_status      in varchar2 := null,
        p_return_rec        out test_rec
    );
end;
/
create or replace package body testpkg as
    --
    procedure main (
        p_id                in varchar2 := null,
        p_admin_status      in varchar2 := null,
        p_return_rec        out test_rec
    )
    is
    begin
      --
      p_return_rec.pid   := 1;
      p_return_rec.pname := 'John Doe';
      --
    end;
    --
end;
  • Data Integration
1 REPLY
Four Stars

Re: tOracleSP returning a RECORD TYPE

I am looking for an example on how to read RECORD type variables in talend