INFORMATICA UNCONNECTED STORED PROCEDURE TRANSFORMATION

CREATE THE BELOW IN ORACLE
=========================================================================

create table emp(eid integer,enm varchar(30),did integer)
insert into emp values(1,'vinaytech',10)
insert into emp values(2,'vinay',20);







create table dept(did integer,dnm varchar(30))
insert into dept values(10,'IT');
insert into dept values(20,'HR')




CREATE PROCEDURE1
=====================
create or replace procedure pr(id in integer, nm out varchar2)
as
begin
select dnm into nm from dept where did=id;
end;
CREATE PROCEDURE2
=====================
CREATE OR REPLACE PROCEDURE pr1(outParam1 OUT VARCHAR2)
IS
BEGIN
 
  outParam1 := 'Vinaytech OUT parameter';
END;


TARGET TABLE
=============

 create table sp_result(eid integer,enm varchar(30),did integer, dnm varchar(30),msg varchar(30))