VB.NET调用存储过程（Oracle），传参数问题，谢谢大家。
CREATE OR REPLACE PROCEDURE EXE_TEST is
ACHAR(8);
BTEST_TBL.D;
CNUMBER(1);
BEGIN
DBMS_OUTPUT.ENABLE;
A := '12345678';
B(1) := '100001';
B(2) := '100002';
TEST(A,B,C);
END ;
/
CREATE OR REPLACE PACKAGE TEST_TBL is
TYPE D IS TABLE OF CHAR(6) INDEX BY BINARY_INTEGER;
END;
/
CREATE OR REPLACE PROCEDURE TEST(A IN CHAR, B IN TEST_TBL.D, C OUT NUMBER) is
========================================================================
现在想在VB里提调用Test这个存储过程，
Dim dbConn As New OleDbConnection
Dim dbComm As OleDbCommand
dbConn.ConnectionString = "Provider=MSDAORA.1;User ID=XXX;Password=XXX;Data Source=XXX;"
dbConn.Open()
dbComm = dbConn.CreateCommand
dbComm.Parameters.Add("A", OleDbType.VarChar, 8).Direction = ParameterDirection.Input
dbComm.Parameters.Add("B", OleDbType.VarBinary).Direction = ParameterDirection.Input
dbComm.Parameters.Add("C", OleDbType.Double, 1).Direction = ParameterDirection.Output
dbComm.Parameters("A").Value = "12345678"
dbComm.Parameters("C").Value = 0
Dim a(0 To 5) As Byte
a(0) = "100001"
a(1) = "100002"
dbComm.Parameters("B").Value = a
dbComm.CommandText = "{CALL TEST(?,?,?)}"
dbComm.CommandType = CommandType.Text
dbComm.ExecuteNonQuery()
dbConn.Close()
请大家帮忙看看，VB里传参数哪里写的不对，谢谢了
[解决办法]
dbComm.Parameters.Add("A", OleDbType.VarChar, 8).Direction = ParameterDirection.Input
dbComm.Parameters.Add("B", OleDbType.VarBinary).Direction = ParameterDirection.Input
dbComm.Parameters.Add("C", OleDbType.Double, 1).Direction = ParameterDirection.Output
A,B是输入，那为什么要给C赋值？
dbComm.Parameters("C").Value = 0
[解决办法]
C不是输出参数么，为什么要赋值？
我的异常网推荐解决方案：oracle存储过程,http://www.myexception.cn/oracle-develop/177537.html
