New procedure
Create a new test form EMP:
CREATE TABLE
EMPNO Number(4)CONSTRAINTPk_empPRIMARY KEY, enameVARCHAR2(Ten), JOBVARCHAR2(9), MGR Number(4), HireDate date,sal Number(7,2), COMM Number(7,2), DEPTNO Number(2)
);
Create a new procedure to insert a record into the EMP table
CREATE OR REPLACE PROCEDUREFirst_procedure asBEGININSERT into"Odi_tag". " EMP1 "(" EMPNO "," ename "," JOB "," MGR "," HireDate "," SAL "," COMM "," DEPTNO ")VALUES('7369','SMITH','Clerk','7902', To_date ('2015-05-05 20:42:11','SYYYY-MM-DD HH24:MI:SS'),' -','1111',' One');END;
ODI Call procedure
ODI Studio configuration topology, new projects, etc. slightly
Project → first folder → process → new process:
Add a subtask item, call a stored procedure
The target command is as follows:
Beginend;
Save, run can
Original address:
http://karanbalkar.com/2013/04/tutorial-18-calling-a-plsql-procedure-in-odi/
Calling a PL/SQL procedure in ODI