Ora Analytic Func: December 2007

OWB Workflow

Today as usual i have browsed some of the links for OWB. I have come across this link in google.
http://cali97.blogspot.com/search/label/OWB
I am sure, out of 4 blogs, i dont have knowledge on 3. Then the blogger have blogged the following about a client interview question which explains about running the process flow from outside.

"I recently was contacted by one of my former clients that had a pretty good question. I actually had this questions asked a few times by various parties, so here is a summery and an answer!"Quick OWB question for you: Is it possible to execute process flows from outside of OWB once they have been created. Wondering if there is a template provided by oracle(like “Sql_exec_template for OWB mappings) to execute Process flows…"Well, OWB does contain a pl/sql package called WB_RT_API_EXEC with a function inside it called RUN_TASK that submits execution requests to the OWB runtime engine. The requests could be for mappings, process flows or scheduled jobs. The function spec looks like:

function run_task
(
p_location_name in varchar2,
p_task_type in varchar2,
p_task_name in varchar2,
p_custom_params in varchar2 default null,
p_system_params in varchar2 default null,
p_oem_friendly in number default 0,
p_background in number default 0)
return number;

This is actually the same function used by the sqlplus_exec_template.sql script in OWB 10gR2 that you mentioned in your email. It can be called using (assuming a repository owner connection exists):

(this is an example…)
declare
result_num number;
begin
result_num:= wb_rt_api_exec.run_task('PFMOD_LOCATION1', 'PROCESS', 'MY_PKG/MY_PF', ',', ',', 0 ,0);
end;

The full documentation of the function can be found in /owb/rtasst/wb_rt_api_exec.pl"

I have to go thru this documentation to update my knowledge. Will update you all on this.
Thanks,
Soma

Musings - OWB Workflow

I already know how to check whether the Control Center (CC) service is available or not using the template sql provided along with the OWB client installation.

I have come across this following thread in Oracle Warehouse Builder forum which explains how we can check the Workflow installation.

http://forums.oracle.com/forums/thread.jspa?threadID=597761&tstart=30

One guy has posted the following query to check the workflow installation.

SELECT
TEXT VERSION
FROM
.WF_RESOURCES
WHERE
TYPE = 'WFTKN'
AND NAME = 'WF_VERSION'".( - default owf_mgr)

I have checked with my repository installation. When I run the query I got table doesn’t exist. In that server we have installed Oracle Workflow (no idea on version).

OWB Useful links

Ora Analytic Func

Monday, December 24, 2007

OWB Workflow

Musings - OWB Workflow

OWB Useful links

Blog Archive

About Me