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!

Insert data from web service into oracle table using PL/SQL

Paul SusantoMar 13 2018 — edited Mar 15 2018

Hi All,

I have a Restful Service : http://services.groupkt.com/state/search/IND?text=pradesh  which will give me the some data

Also I have the below table

CREATE TABLE state_details (

    id             NUMBER(10) PRIMARY KEY,

    country        VARCHAR2(50),

    name           VARCHAR2(50),

    abbr           VARCHAR2(50),

    area           VARCHAR2(45),

    largest_city   VARCHAR2(50),

    capital        VARCHAR2(50)

);

Now my requirement is to read the data using plsql procedure/functions from the service  http://services.groupkt.com/state/search/IND?text=pradesh and insert into STATE_DETAILS table.

Thanks & Regards,

Susanto Paul
This post has been answered by Billy Verreynne on Mar 13 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2018
Added on Mar 13 2018
13 comments
2,300 views