| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 8.1.6 and Web Server 4.0.8.2 - session specific tempor
It appears the developer find the answer in the doc...
I was going through some Oracle documentation and came across the following:
Writing Stateful PL/SQL Stored Procedures
Typically, when a PL/SQL stored procedure is run over the web, its state goes away when the procedure ends. This state information includes the values of any package variables it accesses, its transaction
state, and any rows it inserted into temporary tables.
This anwsers my question. I knew that web was stateless, but I did not know that the state information included rows inserted into temporary tables.
Thanks everyone.
-----Original Message-----
[mailto:Bruce.Reardon_at_comalco.riotinto.com.au]
Sent: Sunday, June 24, 2001 8:16 PM
To: Multiple recipients of list ORACLE-L
tempor
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).
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 Mon Jul 02 2001 - 14:54:23 CDT
 |
 |