ODP.NET

I am trying to bind a SqlDataSource to a Gridview and use stored procedures for Delete. I am getting the following error:

[OracleException (0x80131938): ORA-06550: line 1, column 7:
PLS-00801: internal error [22503|http://forums.oracle.com/forums/]
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

I tried both with .NET's Oracle provider and ODP.NET provider. No luck. This works if I use a sql statement instead of a stored procedure for the DeleteCommand.

Do the stored procedures work with SqlDataSource at all? Thank you.




Here is the code:

<asp:GridView ID="gview" runat="server" Width="100%"
DataSourceID="sqlDS" DataKeyNames="bio_id"
EnableViewState="true" >
<Columns>
<asp:CommandField ShowDeleteButton="True" />
<asp:BoundField DataField="bio_id" HeaderText="Bio ID" />
</Columns>
</asp:GridView>





<asp:SqlDataSource ID="sqlDS" runat="server"
ProviderName="Oracle.DataAccess.Client"
ConnectionString="<%$ ConnectionStrings:dev %>"
SelectCommandType="Text"
SelectCommand="select bio_id from bio "
DeleteCommandType="StoredProcedure"
DeleteCommand="myProc(:bio_id)">
<DeleteParameters>
<asp:Parameter Name="bio_id" />
</DeleteParameters>
</asp:SqlDataSource>