Home -> Usenet -> comp.databases.oracle -> Embedded SQL versus stored procedures

Embedded SQL versus stored procedures

From: Chris Hopkins <Chris_Hopkins_at_Raytheon.com>
Date: Thu, 05 Oct 2000 02:36:14 GMT
Message-ID: <39DBE909.789A48B0_at_Raytheon.com> 






What are the good arguments for one versus the other.  The environment
is a multithreaded C++ application in a turn-key Unix system.  Not a lot
of end user involvement.  No GUI.



In the old days I used "EXEC SQL REPEATED [insert,update,select...] to
cause the Ingres DB engine to cache the SQL and resulting execution
plan.  Does such exist within Oracle Embedded SQL?  Are the mechanics
within the Oracle server smart enough to recognize the same EXEC SQL
block, and therefore automatically make use of a cached execution plan?



Thanks,
Received on Thu Oct 05 2000 - 04:36:14 CEST












Original text of this message