Hi,
Here is a part of the codes in my 'aspx' file but I do have the following error in italic
...
<asp:GridView ID="gv1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="false" DataSourceID="conn" >
<Columns>
<asp:CommandField ShowSelectButton="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="conn" runat="server"
SelectCommand="select fld_a,fld_b from tab_a where rec_id=:rec_id"
providerName="System.Data.OracleClient" ConnectionString="<%$ ConnectionStrings:conn %>" />
<SelectParameters>
<asp:Parameter Name="rec_id" Type="Int32" />
</SelectParameters>
...
Server Error in '/' Application.
--------------------------------------------------------------------------------
ORA-01008: not all variables bound
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OracleClient.OracleException: ORA-01008: not all variables bound
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.