How to bind arrays from 'C' thro' ODBC , while calling a stored procedure (Oracle)

Home -> Community -> Usenet -> c.d.o.server -> How to bind arrays from 'C' thro' ODBC , while calling a stored procedure (Oracle)

From: <suprakash_at_my-deja.com>
Date: Wed, 17 Jan 2001 04:13:57 GMT
Message-ID: <943661$1nb$1@nnrp1.deja.com>

When i try to bind a parameter of type array from 'C' program, which is part of parameter binding for a call to Oracle stored procedure. returns an oracle error saying :
"PLS-00306: wrong number or types of arguments in call to 'DBP_ODBC_TEST2'"

Please could any one suggest on how to pass arrays as parameters to a stored procedure, in which one the parameters are of table type.

Thanks in advance for the help
Suprakash

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 16 2001 - 22:13:57 CST