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] 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

Example24.49.Return The Current Connection ID

SQL> select connection_id();
callret
VARCHAR
__________________________________

1111:4