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