Re: Urgent: SET ROLE in a stored procedure

From: DanHW <danhw_at_aol.com>
Date: 28 Oct 1998 03:32:26 GMT
Message-ID: <19981027223226.06478.00000405@ng97.aol.com>

>i, How can I execute the command SET ROLE from a stored procedure? any help
>would be appreciated. Thank you.
>
>--
>Edward Awad
>Oracle Developer
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

You have to use the dbms_session.set_role function.

Dan Hekimian-Williams Received on Tue Oct 27 1998 - 21:32:26 CST

This message: [ Message body ]
Next message: Michael Skalova: "help on upgrading nt3.51 to nt4 with oracle ver 7.3"
Previous message: Jonathan Gennick: "Re: Oracle SQL Plus 3.3"
In reply to: EdwardAwad_at_webtv.net: "Urgent: SET ROLE in a stored procedure"
Next in thread: Marc Billiet: "Re: Urgent: SET ROLE in a stored procedure"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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