I've been having a problem with procedures parameters, as the order of the parameters is not stable. Sometimes, it deffers.
After having downloaded the sourceforge MyMeta source code, I have found a quick fix (I'm using .NET 2, so don't know about previous versions).
In OracleParameters.cs, I added the following lines just before the call to PopulateArray :
- Code: Select all
DataTable metaData = this.LoadData(OleDbSchemaGuid.Procedure_Parameters,
new object[]{null, this.Procedure.Database.Name, this.Procedure.Name});
//Resort rows based on ORDINAL_POSITION
DataView metaView = metaData.DefaultView;
metaView.Sort = \"ORDINAL_POSITION\";
metaData = metaView.ToTable();
PopulateArray(metaData);
I don't know about Primary Keys (someone else problem), but I suggest to look into a similar fix.
I think the problem comes from OLEDB Schema, which does not return the rows in the same order each time, as it is on my configuration Oracle 10g.
Best regards,
Christian Bourgeois