Reading from a oracle temp table in a separate procedure than the one it was populted in
Posted
by Bob
on Stack Overflow
See other posts from Stack Overflow
or by Bob
Published on 2010-03-30T22:50:42Z
Indexed on
2010/03/30
22:53 UTC
Read the original article
Hit count: 301
I have a 2 stored procedures, the first creates an oracle temp table and the second reads from it. The temp table only has scope for that session. I'm calling the procedures from .Net and the second procedure never returns any results. However if I use the same sprocs and parameters in SQL*Plus it works fine.
I've tried creating an Oracle Transaction object and had hoped I'd be able to read the tables in while still using the same transaction - trying to emulate an SQL Plus type of single connection environment.
Any ideas what I'm doing wrong??
© Stack Overflow or respective owner