Java Development Tools

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!

how to implement asynchronous invocation of oracle PL/SQL stored procedure

TiminFeb 2 2009 — edited Feb 2 2009

Hi friends!

Is there any way to invoke pl/sql stored procedures asynchronously from inside a standard client-server application (not j2ee application)?

I wonder if it is possible without using a dedicated application server.

So i'm not planning to create or deploy any middle tier components (mdb, queues) as well as to deploy my pl/sql procedure as a web service...
but i need to force my main program to continue its execution without waiting while the pl/sql function invoked through jdbc api returns the whole set of extracted rows

Thanks in advance . Any advices, links would be greatly appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2009

Added on Feb 2 2009

#application-development-in-java, #jdeveloper-and-adf

2 comments

860 views