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: 305

Filed under:
|
|

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

Related posts about .NET

Related posts about Oracle