Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: setting v$session.program via OCI?

Re: setting v$session.program via OCI?

From: La, Kyung-tae (³ª°æÅÂ) <hotchild_at_hitel.net>
Date: Tue, 2 Jun 1998 13:47:45 +0900
Message-ID: <6l004o$spv$1@news.nuri.net>


Can you send me the procedure...?
I'm very beginner for Oracle.

Venkat wrote:
>Just run the dbmsutil.sql script from $ORACLE_HOME\rdbmsxx\admin and also
>prvtutil.plb as sys or have your DBA run them. This will create the
>DBMS_APPLICATION_INFO package. This package has a procedure called
>set_client_info which takes a parameter and puts it in the client_info
>column of V$SESSION. I wrote a procedure that calls DBMS_APPLICATION_INFO
>and sets the client_info. All the clients then call the procedure at
>connect time.
>HTH
>Venkat
>
Received on Mon Jun 01 1998 - 23:47:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US