We are tyring to pass in a key/value pair via the connection string to Oracle
9i from a datasource set up using the ColdFusion MX 7.01 Administrator. The
key name is "v$session.program" and the value would be a unique identifier such
as "myApp".

Oracle Session tracking automatically records information on the incoming
connection in the "v$session" table. One of the fields in the "v$session"
table, "Program" is read, when using ColdFusion MX 7.01 Oracle datasource, from
the incoming connection as "JDBC Connect Client". We would like to override
this, and have it contain an application specific value.

Our first attempt was to use the ColdFusion provided Oracle drivers and add in
a key value pair in the "Connection String" field, this did not work. Then we
used the Oracle Client drivers ("OTHER" datasource) and passed this key/value
pair in the URL and then in the "Conneaction String" field, this also did not
work.

Our question is, how do we pass in a custom value from ColdFusion MX 7.01
Oracle Datasource to Oracle such that the Oracle Session tracking table,
"v$session" field of "Program" receives it?

Windows 2000 Server, ColdFusion MX 7.01, IIS 5, Oracle 9.2.0.6

Any help would be appreciated,
Ciaran A. Bolger