[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::sql

Title:SQL notes
Moderator:NOVA::SMITHI
Created:Wed Aug 27 1986
Last Modified:Thu Jun 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:3895
Total number of notes:17726

3876.0. "Finding the name of the current connect" by ukvms3.uk.oracle.com::PJACKSON (Oracle UK Rdb Support) Fri Apr 04 1997 10:04

   A customer is using connections from embedded, static SQL. He wants to
   find out the name of the current connection from within his program. How
   can he do this?
   
   Peter
T.RTitleUserPersonal
Name		DateLines
3876.1NOVA::SMITHIDon't understate or underestimate Rdb!Sat Apr 05 1997 21:127
From Rdb7 and later he can call a stored procedure or MSP such as:

	begin
	get diagnostics :current_connection = CONNECTION_NAME;
	end;

Ian