Re: Oracle8i temporary tables / stored procedures / visual basic

From: Paul Moore <paul.moore_at_uk.origin-it.com>
Date: Tue, 31 Oct 2000 17:44:33 +0100
Message-ID: <K=f+OSUNcUAm1gbxFjEe=574A=CU@4ax.com>

On Tue, 31 Oct 2000 15:32:10 +0100, gastineau_at_my-deja.com wrote:

>When I recreated the temporary table with an explicit "ON COMMIT
>PRESERVE" clause, the stored procedure worked as expected. Although I
>haven't found it specifically (little effort was made), I gather that
>ON COMMIT DELETE" is the default.
>
>I'm a little surprised that this distinction comes into play for a
>single stored procedure that inserts then immediately queries (through
>a ref cursor) the temporary table. It is like an autocommit is
>occurring between those two sections of PL/SQL code.
>
>By the way, ADO is being used.

I think ADO does autocommits by default...

Paul Received on Tue Oct 31 2000 - 10:44:33 CST