Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 8.1.6 and Web Server 4.0.8.2 - session specific tempor

RE: Oracle 8.1.6 and Web Server 4.0.8.2 - session specific tempor

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Sun, 24 Jun 2001 16:32:38 -0700
Message-ID: <F001.00335B2E.20010624161536@fatcity.com>

Hi Chris,

Was the table created to preserve on commit or to delete on commit?

If created as delete on commit then maybe webserver issues a commit between the 2 procedures?

Regards,
Bruce

-----Original Message-----
Sent: Saturday, 23 June 2001 4:43

A developer is struggling with a temporary table issue. He created a session specific temporary table, and is executing two procedures from the web server. The first procedure populates the temporary table, but the second procedure does not see that data. He has worked with another DBA, they tracked his session, and it appears to be the same session. The developer went on and checked his session # from the session as he is running the procedures and it is the same session #. When he tries this from SQL*Plus it works fine.

Since the data is not there, it appears that they are executing from two different sessions, but there testing seems to say otherwise. They searched Metalink and didn't find relevant articles.

Any ideas? Has anyone been in this particular situation?

Many thanks!!!

Chris
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Jun 24 2001 - 18:32:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US