Re: remote access to functionality in a package

"Me" <a_at_a.com.asd> wrote in message news:<3d5e33ba$0$32486$afc38c87_at_news.optusnet.com.au>...
> hi,
>
> I'm new to Oracle technology and I have a problem I hope you can help me
> with.
>
> Once I clean up my forms App and put all business logic into a package I'd
> like to expose the business logic to a java web app.
>
> What should I use? Should I write java data access objects that use JDBC to
> invoke or is there something clever in Oracle to expose package
> functionality to a servlet engine?
>
> Thanks,
>
> Me

If you are referring to Oracle stored package then read on else disregard.

You just grant execute on the package like GRANT EXECUTE ON <Package name> to <User | role>; which will make the packaged procedures/functions/public variables available to that user or role.

Basically you access a public package procedure/function as <Package name>.<Procedure | Function name>

Refer to Statement interface in java.sql API in java docs to access stored Oracle packaged procedures.

//Rauf Sarwar Received on Sun Aug 18 2002 - 00:48:15 CDT