Name
connection_id — get connection identifier
Synopsis
connection_id
(
|
); |
Description
This function returns a string uniquely identifying the connection in this server instance. It is usually a combination of server's port number and a serial number of the client.
![[Note]](images/note.png)
|
Note |
|---|---|
|
The value returned is usually not useful in HTTP invocation context (VSP or SOAP), since consecutive requests by the same client will typically not be on the same connection the way the server sees it. |
Return Values
A VARCHAR connection identifier.
Examples
Example 24.49. Return The Current Connection ID
SQL> select connection_id(); callret VARCHAR __________________________________ 1111:4