[Paulo Larini]

I have problems when calling this simple procedure:


CREATE PROCEDURE aa_read_address2 (lastname CHAR(15));
DEFINE p_lname,p_fname, p_city CHAR(15);
DEFINE p_add CHAR(20);
DEFINE p_state CHAR(2);
DEFINE p_zip CHAR(5);

END PROCEDURE;

using oledb: "Object or provider is not capable of performing requested operation" when choosing stored proc name.
using odbc: "Invalid string or buffer length" on execute

[gurey]

Originally posted by Paulo Larini
I have problems when calling this simple procedure:


CREATE PROCEDURE aa_read_address2 (lastname CHAR(15));
DEFINE p_lname,p_fname, p_city CHAR(15);
DEFINE p_add CHAR(20);
DEFINE p_state CHAR(2);
DEFINE p_zip CHAR(5);

END PROCEDURE;

using oledb: "Object or provider is not capable of performing requested operation" when choosing stored proc name.
using odbc: "Invalid string or buffer length" on execute

Hi,

I think that you must review definition of ODBC, i think the problem is not the SPL.

Gustavo.