Home » Developer & Programmer » Forms » HOW TO OBTAIN THE SESSION NUMBER ?
HOW TO OBTAIN THE SESSION NUMBER ? [message #78195] Mon, 28 January 2002 00:24 Go to next message
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!
Re: HOW TO OBTAIN THE SESSION NUMBER ? [message #78227 is a reply to message #78195] Wed, 30 January 2002 08:07 Go to previous message
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.
Previous Topic: forms 6i (urgent)
Next Topic: Designer CALL_FORM
Goto Forum:
  


Current Time: Thu Mar 28 10:52:49 CDT 2024