Problem with TABLE parameter in TOraStoredProc (6.10.0.9) when OraSession.Option.Net = TRUE
Posted: Tue 07 Aug 2007 13:47
Hello all.
I have problem with TABLE parameter in TOraStoredProc (6.10.0.9) when OraSession.Option.Net = TRUE. Raise exception "Exception EAssertionFailed in module ... at 00138C4A. Unknown data type" on OraStoredProc.PrepareSQL.
My package has
...
TYPE t_varchar2 IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
...
FUNCTION f_function_name
(
a_parameter_v IN VARCHAR2,
a_parameter_tv OUT t_varchar2
) RETURN NUMBER;
...
If OraSession.Option.Net = FALSE or version of ODAC 5.70.1.33 then exeption doesn't raise.
I have problem with TABLE parameter in TOraStoredProc (6.10.0.9) when OraSession.Option.Net = TRUE. Raise exception "Exception EAssertionFailed in module ... at 00138C4A. Unknown data type" on OraStoredProc.PrepareSQL.
My package has
...
TYPE t_varchar2 IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
...
FUNCTION f_function_name
(
a_parameter_v IN VARCHAR2,
a_parameter_tv OUT t_varchar2
) RETURN NUMBER;
...
If OraSession.Option.Net = FALSE or version of ODAC 5.70.1.33 then exeption doesn't raise.
