Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Difference between PreparedStatement and StoredProcedure ?

Re: Difference between PreparedStatement and StoredProcedure ?

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 16 Mar 2007 16:14:23 -0800
Message-ID: <45fb24cf$1@news.victoria.tc.ca>


dean (deanbrown3d_at_yahoo.com) wrote:

: Dynamic SQL is the only simple way to get a sql statement to update or
: select from a changeable table name; in other words if you don't know
: at compile time if you will be selecting from table A instead of table
: B.

And if you put that in a stored procedure then it resides in the database where it is more easily code reviewed, tracked, and monitored. Received on Fri Mar 16 2007 - 19:14:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US