Hi,

I am running a stored procedure which in turn calls another stored procedure (the called proc does some insert into DB2 tables).
Now, this call statement goes fine.

But following this there is an insert statement (insert into a DB2 table), this is where I get the following error:

Exception occurred while running:
A database manager error occurred.SQLCODE: -438, SQLSTATE: 25000 - DB2 SQL Error: SQLCODE=-438, SQLSTATE=25000,
SQLERRMC=SQL30090N Operation invalid for application execution environment


e.g., if proc1 calls proc2, proc1 has something like this:

call proc2 (input parameters)
insert into table1(field1, ...,fieldn)
values (field1,..,fieldn)


When I try running the call statement alone, the procedure runs good.
When I run the insert statement alone, the insert into table goes fine.
But the error occurs only when I have the call statement followed by the insert.

It will be great if someone can throw some light on the reason for this error.

Thanks.

are some of the involved tables : nicknames ?