Re: what is a "module" in the context of DBMS_APPLICATION_INFO.SET_MODULE?
Date: Sun, 20 Jul 2008 15:44:53 GMT
Message-ID: <V3Jgk.145$DS3.65@trnddc01>
"l'il john l'concharoo" <hoochie-coochie.man_at_lingoVEGANcoder.com> wrote in
message news:SaGdnQbBHOz4mh7VRVnyjQA_at_pipex.net...
> "gym dot scuba dot kennedy at gmail" <kennedyii_at_verizon.net> wrote in
> message news:z4Dgk.173$5Q.106_at_trnddc06...
>>
>> Think of set_module as a way of indicating to Oracle where in your
>> application you are. Oracle doesn't care what it is set to. eg If the
>> area of the application is customers you could set it to customer_login,
>> customer_edit, customer_checkout... or whatever you want. It gives you a
>> method of identifying what module in your application you are in.
>> Helpful in debugging.
>> Jim
>>
>
> thanks jim! got it. thats kinda what i thought. but's its good to have it
> confirmed by an expert.
>
> many thanks
>
It especially helps the dba. When the dba sees some application behavior
that is not right then he can at least tell the application developer what
module it is in.
Jim
Received on Sun Jul 20 2008 - 10:44:53 CDT