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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to access API through Web Service in Oracle 11gR2

Ahmed HaroonNov 23 2016 — edited Dec 2 2016

hi all,

HR.@.testdb > select banner from v$version;
BANNER
----------------------------------------------------------
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

assigned a task to access an API through Web Service in Oracle and get XML data (which include Images) in DB via Oracle Forms 10g. ( data is of NIC (National Identity Card) ). I have no knowledge for all of these requirements, so requesting seniors here to help me.

some columns will contain data in Urdu Language and I have to convert it in English before insert in DB via google API

a column Expiry Date will also contain like "Life Time" and others, in case of this string, I have to convert in date to Date of Birth + 100 years at least.

regards
This post has been answered by odie_63 on Nov 28 2016
Jump to Answer

Comments

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

Post Details

Locked on Dec 27 2016
Added on Nov 23 2016
29 comments
3,963 views