Re: [PATCHES] prepareable statements

Neil Conway wrote:

>On Sat, Jul 20, 2002 at 10:00:01PM -0400, Tom Lane wrote:
>  
>
>>AFAICT, the syntax we are setting up with actual SQL following the
>>PREPARE keyword is *not* valid SQL92 nor SQL99.  It would be a good
>>idea to look and see whether any other DBMSes implement syntax that
>>is directly comparable to the feature we want.  (Oracle manuals handy,
>>anyone?)
>>    
>>
>
>I couldn't find anything on the subject in the Oracle docs -- they have
>PREPARE for use in embedded SQL, but I couldn't see a reference to
>PREPARE for usage in regular SQL. Does anyone else know of an Oracle
>equivalent?
>  
>
Oracle doesn't have this functionality exposed at the SQL level.  In 
Oracle the implementation is at the protocol level (i.e. sqlnet). 
 Therefore the SQL syntax is the same when using prepared statements or 
when not using them.  The client implementation of the sqlnet protocol 
decides to use prepared statements or not.  As of Oracle 8, I think 
pretty much all of the Oracle clients use prepared statements for all 
the sql statements.  The sqlnet protocol exposes 'open', 'prepare', 
 'describe', 'bind', 'fetch' and 'close'.  None of these are exposed out 
into the SQL syntax.

thanks,
--Barry