Forum Stats

  • 3,733,838 Users
  • 2,246,829 Discussions


Consuming Rest webservice from forms 12c

MWaseem Member Posts: 189 Blue Ribbon

Can I connect Oracle Forms 12c via Rest web services with shopify database.



  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,627 Employee
    edited June 8

    Yes. You would need to create a Web Service Client in Java. Given there are plenty of examples on the Internet, you likely can get all the code you need doing some searching and copy/paste. I used the example on this page (not affiliated with Oracle):

    After validating that I could get it working outside of Forms, I then use the Forms Java Importer to consume the Java code and access it through Forms PL/SQL. Keep in mind that most examples you find won't take into account the need to parse the returned data (usually in JSON these days), so you will have to add code for that too. Whether you parse the results in Java or PL/SQL is your choice.

    Other, but older examples can be found with this search.

    For future Forms releases, there are plans to make accessing REST that returns JSON easier (no need to write Java code). Stay tuned... 😉

Sign In or Register to comment.