Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > Get result from temporary Oracle Table

Thread Tools

Get result from temporary Oracle Table

Posts: n/a
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.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
anonymous array of strings // ("taking address of temporary"- how long is temporary valid?) C++ 7 02-12-2008 10:58 AM
Displaying oracle table in jsp as a html table Sameer Java 1 10-26-2007 01:17 PM
Get MICROSOFT/CISCO/COMPTIA/ORACLE/SOLARIS Certificaiton Without Exams(Pay After check result)100% passing gaurantee vinay saxena Cisco 0 06-01-2006 12:42 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/ line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
1. Ruby result: 101 seconds , 2. Java result:9.8 seconds, 3. Perl result:62 seconds Michael Tan Ruby 32 07-21-2005 03:23 PM