Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Location
    São Paulo - Brazil
    Posts
    6

    Exclamation Unanswered: ORA-28500 in calling stored procedure in DB2

    I'm trying call a stored procedure in db2 (IBM MVS) from Oracle 8.1.7.
    When I'm calling I received a error code.
    SQL> exec SYSPROC.ZB985A00@STORED_DB2;
    BEGIN SYSPROC.ZB985A00@STORED_DB2; END;

    *
    ERROR at line 1:
    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    TG4DRDA v8.0.4.1.1 grc=0, drc=-30020 (839C,0000), errp=GDJRFS1E
    errmc=1232
    ORA-06512: at line 1


    I appreciate if anybody help me to solve this problem.

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up Re: ORA-28500 in calling stored procedure in DB2

    HI,

    This might be because the connect information to the remote database or the ODBC DSN is not found.

    Add the proper connect string required by the gateway or hs/generic connectivity agent.


    Originally posted by cbarossi
    I'm trying call a stored procedure in db2 (IBM MVS) from Oracle 8.1.7.
    When I'm calling I received a error code.
    SQL> exec SYSPROC.ZB985A00@STORED_DB2;
    BEGIN SYSPROC.ZB985A00@STORED_DB2; END;

    *
    ERROR at line 1:
    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    TG4DRDA v8.0.4.1.1 grc=0, drc=-30020 (839C,0000), errp=GDJRFS1E
    errmc=1232
    ORA-06512: at line 1


    I appreciate if anybody help me to solve this problem.
    SATHISH .

  3. #3
    Join Date
    May 2003
    Location
    São Paulo - Brazil
    Posts
    6

    Re: ORA-28500 in calling stored procedure in DB2

    Originally posted by satish_ct
    HI,

    This might be because the connect information to the remote database or the ODBC DSN is not found.

    Add the proper connect string required by the gateway or hs/generic connectivity agent.
    Hi,
    This is a very interesting, because if I do only a select in db2 table, using the same database link, I receive a answer, see:

    SQL> select * from AXG0202.PADC001V_FILIAL@STORED_DB2;

    PKND_001FILIAL ATSF_001NOME
    -------------- ------------------------------
    1 TESTE
    400 COM PARM
    300 TESTE 02
    123 COM PARM
    124 COM PARM
    SQL>


    So, I think the connection is ok. Is possible exists any parameter that is different for a stored procedure?

  4. #4
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    This could be something to do with privileges. The user name used for creating DB link needs to have execute permission on the stored proc.

    Regards,
    Oracle can do wonders !

Posting Permissions

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