Skip to Main Content
Forums

SQL & PL/SQL

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!

Can java webservice called from dbms_scheduler

907035Dec 10 2013 — edited Dec 10 2013

Hello Guru's,

Currently we have a requirement to fetch the the data from the java web service which is running in our server and pick data from another server and same has to be stored in our oracle db and do some manipulation on the data received.

Please suggest how this can be achieved through oracle scheduler, so that we can automate this process to be run for every day.

Is any has done this please suggest, this is urgent requirement.

Oracle 11gR2, Windows Server 2008

Kind Regards,

Ravi

Comments

BluShadow

Read the FAQ:

Espcecially the point about not asking URGENT questions.

If it's really urgent, raise you issue with Oracle Support.

Hoek

"The scheduler allows you to optionally create programs which hold metadata about a task, but no schedule information. A program may related to a PL/SQL block, a stored procedure or an OS executable file."

ORACLE-BASE - Scheduler (DBMS_SCHEDULER) in Oracle Database 10g

Oracle Jobs executing Java - Stack Overflow

chris227

I dont get your requirements complete i assume, but you may consider to schedule the java-call of the external web-service with a scheduler residing in the java-container and processing the backend-work with advandced queuing.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 7 2014
Added on Dec 10 2013
#from, #java, #webservice
3 comments
2,421 views