How to determine batch/interactive

I'm running
Oracle7 Server Release 7.1.6.2.0 in Unix under korn shell.

I have several database procedures that need to determine if they are called by a batched process ('at' job) or interactive. Certain restrictions are enforced when in batch.

Initially, I created a package function (is_interactive) to return True or False. The function was check the 'TYPE' column from V$SESSION. If 'BACKGROUND' return False else return True. The 'BACKGROUND' does not mark Unix background processes.

Which leaves me with the following question, how can a PL/SQL procedure determine if the current session is batch or interactive?

Thanks in advance,
William Received on Wed Aug 07 1996 - 00:00:00 CEST