Prblems with DataSet Fill

[Probi]

HI,

I have a DropDownList populated from database
I use the following code

OracleDataAdapt er ad2 = new OracleDataAdapt er(cmd2, connection);
DataSet ds2 = new DataSet();
ad2.Fill(ds2);
DataView dw2 = new DataView(ds2.Ta bles[0]);

DropDownList2.V isible=true;
DropDownList2.D ataSource = dw2;
DropDownList2.D ataBind();

for (int j = 0; j < DropDownList2.I tems.Count; j++)
{
DropDownList2.I tems[j].Text = iname[j];
DropDownList2.I tems[j].Selected = false;
}


but I get this error :

Exception Details: System.Data.Ora cleClient.Oracl eException: ORA-01008: not all variables bound


Source Error:


Line 136: DataSet ds2 = new DataSet();
Line 137:
Line 138: ad2.Fill(ds2);
Line 139:
Line 140: DataView dw2 = new DataView(ds2.Ta bles[0]);


Source File: C:\Moj\Moi resenija\aplika cija\pmedit0.as px.cs Line: 138

Stack Trace:


[OracleException (0x80131938): ORA-01008: not all variables bound
]
System.Data.Ora cleClient.Oracl eConnection.Che ckError(OciErro rHandle errorHandle, Int32 rc) +203
System.Data.Ora cleClient.Oracl eCommand.Execut e(OciStatementH andle statementHandle , CommandBehavior behavior, Boolean needRowid, OciRowidDescrip tor& rowidDescriptor , ArrayList& resultParameter Ordinals) +1018
System.Data.Ora cleClient.Oracl eCommand.Execut e(OciStatementH andle statementHandle , CommandBehavior behavior, ArrayList& resultParameter Ordinals) +25
System.Data.Ora cleClient.Oracl eCommand.Execut eReader(Command Behavior behavior) +142
System.Data.Ora cleClient.Oracl eCommand.Execut eDbDataReader(C ommandBehavior behavior) +4
System.Data.Com mon.DbCommand.S ystem.Data.IDbC ommand.ExecuteR eader(CommandBe havior behavior) +7
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +86
aplikacija.pmed it0.project(Obj ect sender, EventArgs e) in C:\Moj\Moi resenija\aplika cija\pmedit0.as px.cs:138
System.Web.UI.W ebControls.List Control.OnSelec tedIndexChanged (EventArgs e) +105
System.Web.UI.W ebControls.Drop DownList.RaiseP ostDataChangedE vent() +134
System.Web.UI.W ebControls.Drop DownList.System .Web.UI.IPostBa ckDataHandler.R aisePostDataCha ngedEvent() +7
System.Web.UI.P age.RaiseChange dEvents() +137
System.Web.UI.P age.ProcessRequ estMain(Boolean includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +4778

can someone tell me what is wrong?

[r035198x]

Where is the PL/SQL that's being used by your program?