Home » SQL & PL/SQL » SQL & PL/SQL » Global variable in Oracle
Global variable in Oracle [message #36742] Sun, 16 December 2001 20:50 Go to next message
RajuKVG
Messages: 13
Registered: December 2001
Junior Member
Hi,
I want to use a global variable in oracle database. So that that variable is present accross all the sessions. Can any one help me how to get it, is there any package which helps achiveing this.

----------------------------------------------------------------------
Re: Global variable in Oracle [message #36744 is a reply to message #36742] Mon, 17 December 2001 04:33 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Store it in a table and access it. that is the only way.

----------------------------------------------------------------------
Re: Global variable in Oracle [message #36749 is a reply to message #36742] Mon, 17 December 2001 07:37 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Suresh is right, a table is the only way. Packages support global variables at the session level - that is one of their main features.

----------------------------------------------------------------------
Re: Global variable in Oracle [message #36782 is a reply to message #36744] Thu, 20 December 2001 02:48 Go to previous message
Phenoracle
Messages: 35
Registered: March 2001
Member
Hi,

You could look at using DBMS_PIPE to hold a value
that can be viewed by all sessions.
This would mean placing the value back into the pipe, as an alternative to placing it in a table it is worth a look at.

Have fun

Phenom



----------------------------------------------------------------------
Previous Topic: A question about triggers (I think!)
Next Topic: UTL_FILE Package
Goto Forum:
  


Current Time: Thu Mar 28 15:49:51 CDT 2024