Hardik’s Info

Hmm, sounds interesting!

Checkout at, here

- Hardik Tank

Share This

Three grand essentials to happiness in this life are:
* Something to do,
* Something to love, and
* Something to hope for. - Joseph Addison

The secret source of humor
itself is not joy, but sorrow.
There is no humor in heave. - Mark Twain

A life spent making mistakes
is not only more honorable
but more useful than a life
spent in doing nothing. - George Bernard Shaw

You will never be happy
Is you continue to search for
What happiness consists of.
You will never live if you are
Looking for the meaning of life. - Albert Camus

Share This

Business Event mechanism provided by Oracle Workflow is a very good tool for customization and to add new business functionality on a particular event. (Mostly asynchronous)

But while coding a subscription function, having event name is not sufficient. Sometimes you will require more parameters to handle the event in a proper way.

For example, you want to use delete or update event of a record and in such cases sometimes it is not possible to fetch older data based on event name or primary key. Using event parameters, code, which raised the event, can pass older data, which may be useful for event subscription.

Following basic code snippet shows, how we can check all the parameters passed with the event.

procedure&nbsp;log_me&nbsp;(t&nbsp;varchar2)&nbsp;IS&nbsp;pragma&nbsp;autonomous_transaction;&nbsp;<br />begin&nbsp;<br />&nbsp;&nbsp;insert&nbsp;into&nbsp;my_log_table&nbsp;values(t);&nbsp;<br />&nbsp;&nbsp;commit;&nbsp;<br />
end;<br /><br />function&nbsp;update_asgn&nbsp;(p_subscription_guid&nbsp;in&nbsp;raw,&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;p_event&nbsp;in&nbsp;out&nbsp;WF_EVENT_T)&nbsp;return&nbsp;varchar2&nbsp;is<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;l_wf_parameter_list_t&nbsp;wf_parameter_list_t;<br />&nbsp;&nbsp;&nbsp;&nbsp;i&nbsp;number&nbsp;:=&nbsp;1;<br />&nbsp;&nbsp;&nbsp;&nbsp;c&nbsp;number;<br />&nbsp;&nbsp;&nbsp;&nbsp;l_key&nbsp;varchar2(30);<br />&nbsp;&nbsp;&nbsp;&nbsp;l_val&nbsp;varchar2(2000);<br />begin<br />&nbsp;&nbsp;l_wf_parameter_list_t&nbsp;:=&nbsp;p_event.getParameterList();<br />&nbsp;&nbsp;c&nbsp;:=&nbsp;l_wf_parameter_list_t.count();<br />&nbsp;&nbsp;<br />&nbsp;&nbsp;log_me('event&nbsp;=&nbsp;'&nbsp;||&nbsp;p_event.getEventName());<br />&nbsp;&nbsp;log_me('count&nbsp;:&nbsp;'&nbsp;||&nbsp;c);<br />&nbsp;&nbsp;<br />&nbsp;&nbsp;while&nbsp;(i&lt;=c)&nbsp;<br />&nbsp;&nbsp;loop<br />&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;l_key&nbsp;:=&nbsp;l_wf_parameter_list_t(i).getName();<br />&nbsp;&nbsp;&nbsp;&nbsp;l_val&nbsp;:=&nbsp;l_wf_parameter_list_t(i).getValue();<br />&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;log_me(l_key&nbsp;||&nbsp;'='&nbsp;||&nbsp;l_val);<br />&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;i&nbsp;:=&nbsp;i&nbsp;+&nbsp;1;<br />&nbsp;&nbsp;end&nbsp;loop;<br />&nbsp;&nbsp;<br />&nbsp;&nbsp;return&nbsp;'SUCCESS';<br />&nbsp;&nbsp;exception<br />&nbsp;&nbsp;&nbsp;&nbsp;when&nbsp;others&nbsp;then&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log_me('errm'&nbsp;||&nbsp;sqlerrm);<br />end;

Here wf_parameter_list_t is a varray. For more information on API please refer Oracle Workflow API Reference

Most important thing is, you can check same at WF_DEFERRED queue log from Oracle Application Manager -> Workflow Manger without writing any code!

Njoy,
Hardik Tank

Share This

This article discusses different combinations of a Struts action class and a form bean and how these combinations can be used.

Struts action mappings By Michael Jouravlev

- Hardik Tank

Share This