Oracle Apps R12下如何定义一个简单的Hello World的Concurrent Program
定义一个表和一个Procedure先
create table ptian_table
(
message_text VARCHAR2(100)
,creation_date DATE
) ;
CREATE OR REPLACE PROCEDURE PTIAN_HELLO (errbuf OUT VARCHAR2, retcode OUT VARCHAR2) IS
BEGIN
INSERT INTO ptian_table VALUES ('Hello World' ,SYSDATE);
END PTIAN_HELLO;
--两个参数用于concurrent program和pl/sql Program的交互
Application Developer职责下: Concurrent > Executable,定义一个新的Executable,Execution File Name为Procedure的名字
切换到Concurrent > Program下,定义Program
然后切换到System Admin职责,Security > Responsibility > Request,把刚定义好的Program绑定到一个Request Group里
接下来就可以执行了,切换到业务职责下,运行Program
运行完毕
用SQL:SELECT * FROM ptian_table;来查看测试表的数据
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7711244
======EOF======
分享到:
相关推荐
EBS java concurrent program的实现
公司Program公司Program公司Program公司Program公司Program
3D Program 常用公式 3D Program 常用公式 3D Program 常用公式
FLASH_Program FLASH Program example
欧姆龙PLC开发工具。CX-Program7.3版本,很好用的一个版本。占用空间少,安装极易简单方便。推荐使用。。。。
Learn how to crack program Tutorial program + example
linux & unix shell program,简单而全面的she'll入门资料
how to program c++ bopu.m, 377 , 2008-05-13 erweihailangboxing.m, 1588 , 2008-05-19 hailangboxing.m, 1222 , 2008-05-18 SDwave.m, 2216 , 2008-04-21 迭加法一维.doc, 83968 , 2008-05-12 叠加法二维....
CAP(Cryptographic Analysis Program)是由DR. Richard Spillman专门为教学而研制的密码制作与分析工具。
program sql
C How to Program is a comprehensive introduction to programming in C. Like other texts of the Deitels’ How to Program series, the book serves as a detailed beginner source of information for college ...
program_life_cycle short discript of program life cycle
英文版 C++ How to Program 10th ediiton C++ How to Program 10th ediiton
Epson Adjustment program_L130_L220_L310_L360_L365.rar
英文版 Java learning to program with robots
ghost program this is my best program
SAP BAPI program example
最新卸载update Program官方程序
zip program.jar to open zip file
Python How to Program