Calling a PL/SQL procedure in ODI
来源:互联网 发布:数据魔方为什么下线 编辑:程序博客网 时间:2024/06/10 11:56
新建procedure
新建一个测试表格EMP:
CREATE TABLE EMP(
EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,ENAME VARCHAR2(10),JOB VARCHAR2(9),MGR NUMBER(4),HIREDATE DATE,SAL NUMBER(7,2),COMM NUMBER(7,2),DEPTNO NUMBER(2)
);
新建一个procedure,往EMP表插入一条记录
CREATE OR REPLACE PROCEDURE first_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'), '800', '1111', '11');END;
ODI 调用过程
ODI Studio配置拓扑结构, 新建项目等略
项目→第一个文件夹→过程→新建过程:
添加子任务项,调用存储过程
目标命令如下:
begin first_procedure(); end;
保存,运行即可
原文地址:
http://karanbalkar.com/2013/04/tutorial-18-calling-a-plsql-procedure-in-odi/
0 0
- Calling a PL/SQL procedure in ODI
- Calling a Stored Procedure in a Database
- Calling a Stored Procedure in a Database
- PLS-2--25Using Parameters in PL/SQL Procedure
- 59.In your database, the current status of a PL/SQL procedure has become INVALID. Which action woul
- My First PL/SQL Procedure
- My Second PL/SQL Procedure
- Problem - Slow PL/SQL procedure
- Oracle Procedure (PL/SQL) 实践归纳
- PL/SQL-procedure-function-package创建
- Assignment 1: PL/SQL stored procedure P9
- PL/SQL Procedure out varchar2 最大长度
- ADF BC. PL/SQL procedure params.
- PL/SQL-procedure-function-package创建
- VBA宏调用Oracle PL/SQL Procedure
- PL/SQL 测试 调用PROCEDURE 和FUNCTION
- Using Variables in ODI: Creating a Loop in a Package
- Calling a Function in a Database
- Java枚举
- SCD Type2 in ODI
- linked list summary
- Effictive C++导读
- 动态规划法(一)
- Calling a PL/SQL procedure in ODI
- linux多线程服务端编程读书笔记——第三章
- Android 将软键盘Enter变为搜索
- Dreamoon and Sets_Codeforces
- 网易2017校园招聘笔试题 回文序列
- STL中vector,Map,Set的实现原理
- Androidapk瘦身
- 5. Longest Palindromic Substring
- 自定义view的相关知识