Re: what is a "module" in the context of DBMS_APPLICATION_INFO.SET_MODULE?

From: gym dot scuba dot kennedy at gmail <>
Date: Sun, 20 Jul 2008 15:44:53 GMT
Message-ID: <V3Jgk.145$DS3.65@trnddc01>

"l'il john l'concharoo" <> wrote in message
> "gym dot scuba dot kennedy at gmail" <> 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

Original text of this message