Re: Developer 2000: can't change a role

Mike,

[Quoted] [Quoted] I don't know if you had any success with Neville's suggestion but we are still getting Oracle error messages when trying to set role. If you or Neville have a solution could you please give us some further details.

Regards
Pali Bains

Neville Sweet <sweet.neville.nj_at_bhp.com.au.no_junk_email> wrote in article <8ak9sn$66q$1_at_gossamer.itmel.bhp.com.au>...
> Hi Mike,
>
> Don't know if it will help, but we call a procedure in a forms library that
> successfully calls dbms_session.set_role.
>
> Mike Kogan wrote in message <38CCA4B6.8956EFC2_at_mtt.cell.ru>...
> >I tried to do this but "ORA-06565" (cannot execute SET ROLE from within
> >stored procedure) was occurred.
> >
> >Malcolm Campbell wrote:
> >
> >> The problem probably lies in the fact that forms pl/sql is slightly
> >> different from server pl/sql.
> >>
> >> One way around the problem would be to write a database pl/sql package
> >> compile it on the
> >> database then call the server package from the form.
> >>
> >> Good luck, Malcolm.
> >
> >>
> >
> >>
> >> Mike Kogan <kogan_at_mtt.cell.ru> wrote in message
> >> news:38C8C58D.6CAFF3F8_at_mtt.cell.ru...
> >> > Hi everyone!
> >> >
> >> > I use Developer/2000 Forms 5.0.6.19.0 with OracleServer 7.2
> >> > While the code
> >> >
> >> > begin
> >> > DBMS_SESSION.SET_ROLE('a_role identified by passwd');
> >> > end;
> >> >
> >> > is being executed the error "ORA-00600" is occurred.
> >> > But the same code is being executed from SqlPlus correctly.
> >> > Can you give me any advice? What is the way out from the situation?
> >> >
> >> > Thank you very much for your help and kind attention.
> >> >
> >> >
> >> > --
> >> > Best regards,
> >> > Mike Kogan
> >> >
> >> >
> >> >
> >> >
> >
> >--
> >Best wishes,
> > Mike
> >
> >
>
>
>
Received on Tue Mar 14 2000 - 16:26:13 CET