Re: Developer 2000: can't change a role

[Quoted] 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 - 03:58:05 CET