DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Manipulating data from an Oracle temporary table in VB.Net

687520Sep 7 2010 — edited Sep 10 2010

Hello,

I have a VB.Net application that populates an Oracle 11g global temporary table (using 'ON COMMIT PRESERVE ROWS'). I can see data in the temporary table by loading it into a grid in my VB.Net application and everything looks correct.
However, when I call an Oracle stored procedure from VB.Net that would manipulate the data in this temporary table, the stored procedure reports that my temporary table is empty.

I understood that data in an Oracle global temporary table should be visible to all sessions so I'm not sure why this is happening and what the solution would be.
I am using Visual Studio 2010 and installed ODAC 11.2.0.1.2
Please advise.

Regards,
M. Rusu

Edited by: user7047382 on Sep 7, 2010 12:42 PM

Edited by: user7047382 on Sep 7, 2010 12:44 PM

Edited by: user7047382 on Sep 7, 2010 1:27 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2010

Added on Sep 7 2010

#net-stored-procedures, #windows-and-net

5 comments

4,842 views