Aggregator | Books | Industry News | Firefox Plugins | Social | Links

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 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, 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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)