Re: Oracle8i temporary tables / stored procedures / visual basic

On Tue, 31 Oct 2000 00:21:51 +0100, gastineau_at_my-deja.com wrote:

>I'm attempting to use a temporary table in a complicated stored
>procedure. The stored procedure populates the temporary table then
>immediately uses it as the central table in a ref cursor query (all
>other tables are outer joined to the temporary table). The results are
>returned through a stored procedure parameter.
>
>The procedure works when run from SQL*Plus, but when run from Visual
>Basic, it appears that the temporary table is empty when the cursor
>query is executed. I say this because replacing the temporary table
>with "dual" in the query causes one record to be returned (it was empty
>before).

You don't say how you are connecting to the database in VB, but it sounds like the procedure is being run in a session which is either no longer available, or not the same as the one VB is using. Rereading that statement, it sounds dreadfully vague, but maybe you can see what I mean :-)

Please describe what method you are using to connect from VB. If it is ADO/OLE DB for instance, I know that ADO pools connections for use by clients - it may be that this is affecting you.

Paul. Received on Tue Oct 31 2000 - 03:37:41 CST