Hi,

i would like to call a stored procedure that has a record as
parameter.
The record has some attributes that are declared in a different
package.

e.g:

PACKAGE BODY Package1

PROCEDURE Validate(pi_record IN Package2.RECORD1)

....
End;
END; -- Package1

PACKAGE Package2
TYPE RECORD1 IS RECORD
(
param1 tparam1%TYPE,
param2 tparam2%TYPE,
param3 tparam3%TYPE
);
End; --Package2

I try to call the procedure from vb.net like:

strConnection = "some databaseconnection..."
objOracleCommand = New OracleCommand
objOracleConnection = New
OracleConnection(strConnection) objOracleConnection.Open()
With objOracleCommand
.Connection = objOracleConnection
.CommandType = CommandType.StoredProcedure
.CommandText = User.Package1.Validate

For Each objNcCName As param In parameters


'here is the problem:

..Parameters.Add("pi_record.param1",
paramType.VARCHAR,500,ParameterDirection.Input) = param.value1

..Parameters.Add("pi_record.param2",
paramType.VARCHAR,500,ParameterDirection.Input) = param.value2

..Parameters.Add("pi_record.param3",
paramType.VARCHAR,500,ParameterDirection.Input) = param.value3


Next

I get an oracle error:
"ORA-01036: Variablenname/-number invalid.


How is it possible to access this oracleparameter?
Has someone an idea to solve this problem?

Thank you for your help!

Tobias Thurn