Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Unanswered: SQL30090N while running stored proc

    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.
    Last edited by crisjul; 09-22-11 at 04:43.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    are some of the involved tables : nicknames ?
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •