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

    Lightbulb Unanswered: HELP - Error when call a stored procedure with gateway

    Hi all,
    I'm trying to call a stored procedure in DB2 IBM Mainfraime from oracle 8.1.7 using the gateway.
    When I called I recived the error:

    SQL> exec sysproc.zb987a00@STORED_DB2;
    BEGIN sysproc.zb987a00@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


    The DBlink is ok, because If I do a single select, it's ok.

    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
    853 TESTE COM PARAMETRO

    6 rows selected.

    Help, I need this execution urgentilly

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    You should post this in a DB2 forum.

    however, could it be a privilege issue?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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