Comments
| XML-Over-HTTP (REST Web Services) From PL/SQL - XML-over-HTTP was the precursor to web services allowing easy access to XML via HTTP GETs and POSTs. |
Lesio said... Quite interesting 10 points :) |
Rashid said... Very helpful article, thank you. One thing tripped me up. The example URLs which take a parameter; e.g.http://test:test@myserver:8080/xml_demo/xml_api.get_emp_1&p_empno=7369 should use a question mark after the proc name: http://test:test@myserver:8080/xml_demo/xml_api.get_emp_1?p_empno=7369 The ampersand symbol is to delimit additional parameters; e.g. http://test:test@myserver:8080/xml_demo/xml_api.get_car?p_make=ford&p_model=mondeo |
Tim... said... Hi.Thanks for pointing out the typos. Pesky cut & paste. :) Cheers Tim... |
Glenn said... Nice simple steps. Thanks |
Jumaa said... Thanks Tim for this helpful exampleI have one question: How can I do the same example using (https) instead of http? |
Tim... said... Hi.The https configuration is done on your app server, not in PL/SQL. If you are using the Embedded PL/SQL Gateway, you can set it up using this guide. http://wiki.shellprompt.net/bin/view/Apex/SSLandAPEXxdbHttp?TWIKISID=20c54428f4558c81608149b254e72ad4 Cheers Tim... |
Mark said... Hi TimI have done your tutorial which works great, but I want to grant another user the permission to use the created DAD and created PACKAGE xml_api so what I did I created another user (test2) with the following privileges: 1- select on test.emp & test.dept 2- DBMS_EPG.authorize_dad ('xml_demo','TEST2') 3- execute xml package xml_api cont.... 1/2 |
Mark said... but whenever I test the same web service for the newly created user (test2)I got the following error message: The requested URL /xml_demo/xml_api.get_emp_1 was not found on this server although it works fine with user test thanks for your help 2/2 |
Tim... said... Hi.Please ask questions in the forum, not here! Different user. Different DAD. Simple. The DAD exposes a specific schema. Cheers Tim... |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!