OraFAQ Forum: Forms » HOW TO OBTAIN THE SESSION NUMBER ?

Home » Developer & Programmer » Forms » HOW TO OBTAIN THE SESSION NUMBER ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOW TO OBTAIN THE SESSION NUMBER ? [message #78195]

Mon, 28 January 2002 00:24

sorcer
Messages: 19
Registered: January 2002

Junior Member

Hi,
I'm programming in Pro*C and i want to obtain the number session to create a temporary table ex :
CREATE TABLE TMP_TABLE_numbersession...
where numbersession is unique.
Can you help me?
Thank you!

Report message to a moderator

Re: HOW TO OBTAIN THE SESSION NUMBER ? [message #78227 is a reply to message #78195]

Wed, 30 January 2002 08:07

Rafael Luciano do Rosario
Messages: 4
Registered: January 2002

Junior Member

This command works in SQL*Plus and oracle forms:

select userenv('sessionid')
from dual;

I hope it helps you.

Report message to a moderator

Previous Topic:	forms 6i (urgent)
Next Topic:	Designer CALL_FORM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 14:59:41 CST 2025