Problem with TABLE parameter in TOraStoredProc (6.10.0.9) when OraSession.Option.Net = TRUE

AndySphinx · Post by **AndySphinx** » 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.

Plash · Post by **Plash** » Tue 07 Aug 2007 15:16

We have fixed this problem. The fix will be included in the next build of ODAC.

AndySphinx · Post by **AndySphinx** » Wed 08 Aug 2007 06:06

Thanks. I will be wait impatiently.