Re: Developer 2000: can't change a role

From: Malcolm Campbell <campbellma_at_logica.com>
Date: Fri, 10 Mar 2000 14:49:28 -0000
Message-ID: <8ab21q$8a6_at_romeo.logica.co.uk>


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

[Quoted] 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
>
>
>
>
Received on Fri Mar 10 2000 - 15:49:28 CET

Original text of this message