Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: webservice
"prunoki" <hegyvari_at_ardents.hu> schreef in bericht
news:01da4707-973c-447d-a7b1-8e5a862b4ecb_at_d4g2000prg.googlegroups.com...
> On nov. 27, 14:32, "shakespeare" <what..._at_xs4all.nl> wrote:
>> "prunoki" <hegyv..._at_ardents.hu> schreef in
>> berichtnews:1ed61ee8-3942-4e2e-946a-ac7a2c43374e_at_s8g2000prg.googlegroups.com...
>>
>>
>>
>> > Hello,
>>
>> > Any ideas about the practical (and working) way of exposing the result
>> > of pl/sql functions as webservices?
>>
>> > A function would look like this:
>>
>> > function something (par1, par2) return some_table_type, so that the
>> > function could be invoked like
>>
>> > select * from table(function(par1,par2))
>>
>> > Currently I am looking at jdeveloper and application server. Anyone
>> > here implemented something like this? The core of an existing
>> > application is written in pl/sql, thick clients connect to it but we
>> > would like to present some services to the other applications using
>> > web services. We would like to keep all the application logic inside
>> > the database so what we need is a kind of a wrapping aroung these pl/
>> > sql-s.
>>
>> > Regards,
>>
>> > Krisztian
>>
>> Create a package, right mouse click, expose as webservice.
>>
>> Shakespeare
>
> Thanks. Whatever it does, can you deploy it into a Sun Application
> Server or does it have to be an Oracle Application server?
mmm I don't know that. Maybe one of the others? I only deployed them on Oracle Application Server.
Shakepeare Received on Thu Nov 29 2007 - 13:55:41 CST
![]() |
![]() |