This forum is currently locked. You can't register or post questions at this time. (read more)

Native Procedure Web Service

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

dfimble
Member
Posts: 2
Joined: Mon Sep 09, 2013 7:04 pm

Native Procedure Web Service

Postby dfimble » Tue Sep 10, 2013 12:47 pm

I am able to call Stored Procedures through Web Services now directly from the DB, but am running into an issue returning back records or sets of data. The only way to return a record, is to define the record at the schema level and return this back. This is a lot of work and will cause large numbers of Record Types to exist.

For returning records of data, is there a better way to do this?

For returning sets of data, is there a way of doing this?

David

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Native Procedure Web Service

Postby Tim... » Tue Sep 10, 2013 12:49 pm

Hi.

Have you considered using REF CURSORS.

http://www.oracle-base.com/articles/mis ... rdsets.php

Another alternative is to use queries against pipelined table functions.

http://www.oracle-base.com/articles/mis ... ctions.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

dfimble
Member
Posts: 2
Joined: Mon Sep 09, 2013 7:04 pm

Re: Native Procedure Web Service

Postby dfimble » Tue Sep 10, 2013 3:12 pm

Neither of these approachs works for DB Hosted Web Services. I am currently able to have the DB host the Web Service using XDB functionality, such that any Stored Procedure written is automatically available via a Web Service. The issue is that it only seems to work for specific output types (NUMERIC, DATE, DATETIME, VARCHAR2, CLOB). I am looking to see if there is a way of returning a set of data using the Web Service functionality.

If this were possible, then it would avoid having to host a seperate Web Service on the application server...

David

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Native Procedure Web Service

Postby Tim... » Tue Sep 10, 2013 3:47 pm

Hi.

OK. I see what you are saying. I misunderstood your original question...

You always have the option of creating the web service manually. See:

http://www.oracle-base.com/articles/mis ... r-http.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 3 guests