8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for XML-Over-HTTP (REST Web Services) From PL/SQL


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 example

I 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 Tim

I 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! They will be deleted!

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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.