Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: setting v$session.program via OCI?
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