请问高手:oracle存程过程的参数是数组类型,请问我在vb中调用此存程过程时对这个数组类型的参数该怎么写??例如:
Public Function FA(ByVal p_sn As String, 数组类型的数据[]) As String
OraDatabase.Parameters.Add "p_sn", p_sn, ORAPARM_INPUT
OraDatabase.Parameters("p_sn").serverType = ORATYPE_VARCHAR2
??
??
Set OraSqlStmt = OraDatabase.CreateSql("Begin FA.FAA(:p_sn,:[]); end;", 0&)
End Function
Public Function FA(ByVal p_sn As String, 数组类型的数据[]) As String
OraDatabase.Parameters.Add "p_sn", p_sn, ORAPARM_INPUT
OraDatabase.Parameters("p_sn").serverType = ORATYPE_VARCHAR2
??
??
Set OraSqlStmt = OraDatabase.CreateSql("Begin FA.FAA(:p_sn,:[]); end;", 0&)
End Function
为何不把数组分解一下呢.
OraDatabase.Parameters.Add "p_sn0", p_sn[0], ORAPARM_INPUT
OraDatabase.Parameters.Add "p_sn1", p_sn[1], ORAPARM_INPUT
....OraDatabase.Parameters.Add "p_snx", p_sn[x], ORAPARM_INPUT