carlo,
you can use the communication between oracle in a specific nature as
described by james which means that a lot of your application/business logic
would reside in the java code possibly on the server. the problem with this
approach is that every time you need to upgrade your application the java
classes need replacing, which may be ok, but for me this became a real
problem.
so now i pass the context of what the user wants to do to with the database
to the stored procedure, this gave me the facility to simply change the
stored procedure(s) and execute completely different application/business
logic. this also allows us to develop web applications using standard
pl/sql, carry out upgrades by simply importing the database and fix problems
remotely [user sites] in real time by manipulating the tables/stored
procedures.
hope this has given you food for thought. incidentally the company sell the
engine, if you mail me direct i will send you the link.
kind regards
ray
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Carlo
> Indolfi
> Sent: 21 May 1999 10:13
> To: [EMAIL PROTECTED]
> Subject: Stored Procedures.
>
>
> Hi to all!!!
>
> Is possible with servlets, or more in general, with Java a kind of
> management of Oracle's Stored Procedures, such as query,
> bring a ResultSet returned from the Stored Procedure, bring a
> value or more values returned from the Stored Procedure??
>
> Thank's in advance
> Regards
> Carlo :^)
>
> __________________________________________________________________
> _________
> To unsubscribe, send email to [EMAIL PROTECTED] and include
> in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
