[RESOLVED] PostgreSQL Maximum Arguments

[Foxy69]

Does anybody know of a limit to the number of arguments in a STORED FUNCTION when making a call through the PostgreSQL ODBC driver.

I have a function with 98 arguments and if I call it through the SQL Editor in pgAdmin it works fine, yet if I call it from VB.Net it errors on the 39th and 79th arguments.

I'm 100% sure the VB code's not at fault as its working on another database, the only code I have had to change for PostgreSQL in VB was a 'call <function>' to 'select <function>'. The data types around where it errors are all 'CHAR'.

Thanks

[Foxy69]

Sorry!, sorted it. VB was calling some of the arguments as DOUBLE but I noticed the FUNCTION had converted the data type to numeric. I changed VB OdbcType.Numeric and it worked.