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)
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.
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be