Get result from temporary Oracle Table

F

Franck

Hi,
Having problem with temporary table from Oracle.
Runing my stored procedure (which stores an amount of row in a
temporary table) from an Sql Tool works great !

Trying to return the same result from my webmethod fails telling me
"object no longer exists".

I think I understand why as result is linked to a session call and
disappears when Oracle session ends but I can't figure out a way to
solve my problem, regarding the fact I don't want a fixed table.

Thks for help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
474,266
Messages
2,571,082
Members
48,773
Latest member
Kaybee

Latest Threads

Top