Re: Making my program known to SQLDBA

From: Burton V. Peltier <ep94bvps_at_noh71cd.shell.com>
Date: 1995/07/12
Message-ID: <DBM3wE.IyA_at_shellgate.shell.com>#1/1


In article <DBIICy.4wp_at_shellgate.shell.com>, ep94bvps_at_noh71cd.shell.com (Burton V. Peltier) writes:
>> In article <DBAx4I.65I_at_inter.NL.net>, E.W.Vergragt_at_inter.nl.net (Edward W. Vergragt) writes:
>> >> mikecollins_at_cix.compulink.co.uk ("Michael Collins") wrote:
>> >>
>> >>
>> >> >Just out of interest .. does anyone know how to link or write a PRO*C
>> >> >program so that it's name will appear in the SQLDBA monitor processes
>> >> >display like the Oracle tools SQL*PLUS, forms etc do ?
 

>> >> >Thanks in advance
 

>> >> >MikeCollins_at_cix.compulink.co.uk
>> >>
>> >> We develop SWM*Toolset, a complete building-environment for Oracle
>> >> (SQL*Forms lookalike, inl. report, menu, CASE, etc). We also wanted to
>> >> made our product 'visible' in SQL*Dba. We checked with Oracle
>> >> support, the Netherlands but got the answer that this is NOT possible.
>> >> Our product appears as ???, in stead of sql*plus_at_swm:A.
>> >>
>> >> Please keep me informed...
>> >>
>> >> Regards
>> >>
>> >> SWM Automatisering
>> >> Edward Vergragt
>> >>
>> >>
>>
>> Try this , which works on SunOs but not on HP-UX...
>>
>>
>> extern char *siprgnm;
>> extern void sisvpnm();
>> void OdeSetName();
>> void OdeSetName(name)
>> char *name;
>> {
>> sisvpnm(name);
>> }
>>
>>
>> Place the above code right before "main ()".
>>
>> --
>> *****************************************************
>> * Burt Peltier Shell Offshore ep94bvps_at_shell.com *
>> * (504) 588-0179 701 Poydras #1660 New Orleans 70139*
>> *****************************************************

One more time...

Include the following right after "main()", and it WILL work on HP-UX.

   OdeSetName("sample1");

   Where "sample1" is your program name.

-- 
*****************************************************
* Burt Peltier Shell Offshore    ep94bvps_at_shell.com *
* (504) 588-0179 701 Poydras #1660 New Orleans 70139*
*****************************************************
Received on Wed Jul 12 1995 - 00:00:00 CEST

Original text of this message