Long insert statement in PCC ireclen exceeded.

I have a long insert statement in PRO*C insert into table ( ....) values (...) ireclen is exceeded.

I tried
char stmt[1000];
sprintf(stmt,"insert into ... values (:v1,:v2);"); exec sql execute s using :val1,:val2 .... but even then the exec sql execute s using is about 300 chars long.

is there any way out other than using :a1,:a2 as variable names.

Aniruddha Kortikar (kortikar_at_mipos2.intel.com)

E-mail 	: kortikar_at_mipos2.intel.com | A billion here, a billion there ...
Phone(W): 408 765 5515              | pretty soon it adds upto real money.


-------------------------------------------------------------------------------