Re: help:alter session set current_schema does not work in pl/sql

I assume that you have checked and that no AQ$_QUEUES table exists in the TEST schema?  

u518615722_at_spawnkill.ip-mobilphone.net (Mike F) wrote:

>We are using 817.3 on solaris
>
>
> 1 create or replace PROCEDURE test
> 2 ( user_IN IN VARCHAR2 )
> 3 AS
> 4 dummy1 varchar2(20);
> 5 BEGIN
> 6 execute immediate 'alter session set current_schema = ' || user_in;
> 7 select table_name
> 8 into dummy1
> 9 from user_tables where rownum < 2;
> 10 sys.dbms_output.put_line(dummy1);
> 11* END;
>
>SQL> /
>Procedure created.
>
>SQL> exec system.test('TEST');
>AQ$_QUEUES
>
>PL/SQL procedure successfully completed.
>
>The expected result should be TEST as well.
>
>What is wrong here?
>Thanks for your help.
>
>
>
>
>
>
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Feb 26 2002 - 13:26:13 CST