This is Shahbaz , writing my first post :)
I am struggling with some issue in VB.Net, the requirement is to pass the parameter as an Arraylist to Oracle Stored Procedure, Pleae find my code below, am getting error, dont know what am missing, if anyone has idea /has worked on it. Please guide me, your help will be greatly appreciated.
Dim oracleparam As OracleParameter = cmdCommand.Parameters.Add("P_IDS", OracleDbType.Decimal, ParameterDirection.Input)
'let's make it a PSQLAssociative Array
oracleparam.Value = mArrBuildingList
oracleparam.CollectionType = OracleCollectionType.PLSQLAssociativeArray
cmdCommand.ArrayBindCount = mArrBuildingList.Count
Conn = New OracleConnection
Conn.ConnectionString = ConnStr
cmdCommand.Connection = Conn
cmdCommand.CommandText = "CRSTOOLS.CMT_PKG_APPLICATION.SP_Array_Test"
cmdCommand.CommandType = CommandType.StoredProcedure
cmdCommand.ExecuteNonQuery()error is , OracleParameter is InValid
Thanks and Regards,