OracleCommand.Prepare Method

Creates a prepared (or compiled) version of the command at the data source.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in

virtual void Prepare () override
public void Prepare ()
public override function Prepare ()

Exception typeCondition


The Connection is not set.


The Connection is not .Data.OracleClient.OracleConnection.Open.

Before you call Prepare, specify the data type of each parameter in the statement to be prepared.

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1