inncoggnitto
Programmer
our oracle db is set so that in order to execute a stored procedure the users password, id and role must be passed (oracle will only allow a vb application to connect if it is running from an exe (executable) file). to do so first must connect then pass the following
varSetRole = "BEGIN DBMS_SESSION.SET_ROLE(tsec.srole('mum_app')); END;"
cn.Execute varSetRole
i want to run the stored procedure from the crystal report, which works just fine in the development environ where no role is required. i cannot find an object for crystal to pass the role.
anybody have any ideas?
varSetRole = "BEGIN DBMS_SESSION.SET_ROLE(tsec.srole('mum_app')); END;"
cn.Execute varSetRole
i want to run the stored procedure from the crystal report, which works just fine in the development environ where no role is required. i cannot find an object for crystal to pass the role.
anybody have any ideas?