Re: PRO*C & PL/SQL Stored procedure

I was wondering if someone noticed a strange behaviour of Pro*C apps that pass a number of PL/SQL table types as parameters for stored procedures in Oracle 8i R2 (8.1.6)?
The app was running just fine on Oracle 7, but developers tried to migrate to Oracle 8.1.6 , compiled successfully their packages in 8.1.6, but get an ORA error at run time - parameter too long (don't remember the error number). App passes in excess of 50 table types, but it was not a problem pre-8.1.6.

Any ideas?

Thanks, Alex Sokol

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat May 27 2000 - 00:00:00 CDT