help: cursor does not want to fetch ....ORA-03232 ???

From: Jan Kucharski <jkucharski_at_altavista.net>
Date: Fri, 18 May 2001 10:52:42 +0100
Message-ID: <MPG.156f01009ac92e979896b3@news.demon.co.uk>

Hi

In my plsql code I have the following:

procedure test is
--

cursor get_configuration_cur is -- (i_restart integer := 0)

        select * from t_name;
--

get_configuration_rec get_configuration_cur%rowtype;

--

begin

    open    get_configuration_cur;
    fetch   get_configuration_cur into get_configuration_rec;
    close   get_configuration_cur;

    --
    dbms_output.put_line('success and commit ');     commit;
    --
exception

    when others then

        raise_application_error ( -20000, SQLCODE || SQLERRM );
        rollback;

end;

And the problem is that the cursor does not want to fetch !!!. I can open it and close but when I enable fetch line it hangs.

I do not (!) get the error message either, but am suspicious about ora:ORA-03232

I tried to run the 'select * from t_name' on its own ( outside procedure) and it is blazing quick. It seems that the action of FETCHING INTO RECORD causes the problem.

What can be a problem ? Anybody has any ideas ?

Thanks,

Jan
jkucharski_at_altavista.net Received on Fri May 18 2001 - 04:52:42 CDT