| Web Service /XML / JDeveloper Question [message #205386] |
Fri, 24 November 2006 07:33 |
jdeponte
Messages: 7
Registered: June 2005
|
Junior Member |
|
|
Hi,
I have to design an automatic -and periodic- process that performs next tasks:
1) Read Oracle table to build a XML file
2) Connect with a Web Service and send the XML. (In the specification says that SOAP with attachments is not supported , so we have to use a "proxy J2EE client" to interact with this web service)
3) Also this web service uses security sign with a X.509 v3 certificate in BASE64, which must be passed as a 'string' parameter when is invoked.
I'm new in these subjects, and I need some help, my questions:
1) Is it possible to define an automatic process with JDEVELOPER that connects to the DB, build the XML file and invoke the Web service?
2) How could I make this proccess automatic and periodic, for example every friday.
3) What are the tools I have to use:
3.1.- To Connect with DB -> JDBC?
3.2.- To Build XML, programmatically? or is there any tool?
3.3.- To define it as a periodic proccess??
4) Others alternatives? Is it possible to develope this directly in PL/SQL as a job in ORACLE?
thanks in advance...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
