CF & ORACLE Package procedue

[LongHorn]

My Oracle DBA has set up an account that must be activated by the application program. She said to execute the following code to enable the application update role :

EXECUTE DBMS_SESSION.SET_ROLE(TSEC.SROLE('<application_name>'));

I don't know where to issue this command from my CF APP.

I am so used to passing the user_id and the password in my cfquery statement like this
<cfquery name=&quot;applproj&quot; datasource=&quot;#AIRname#&quot; DBtype=&quot;#DBtype#&quot;
username=&quot;#AIR_username#&quot; password=&quot;#AIR_password#&quot; >

Please help.
Thanks,
Longhorn

 

[pcorreia]

Have you tried it between the <CFQUERY> tags? My experience to date has been that everything between the <CFQUERY> tags gets passed to the database as if it were the text of one big sql script. I would try putting it at the top of your query, above the statement you're actually trying to execute. The only problem you might have is if this statement returns some result -- that could get misinterpreted as the result of the query. Try it out and let us know!