Re: Developer 2000: can't change a role

[Quoted] 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
> >
> >
> >
> >

--
[Quoted] Best wishes,
 Mike