IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Invoke Stored procedure in HP Linux box

    Posted Wed October 22, 2008 05:46 PM

    Originally posted by: SystemAdmin


    Hi,

    I am working on Windows 2000 and WTX 8.1. My map calls a stored procedure (sp) in Oracle 10g. I am able to invoke the sp successfully, when running the map in the Windows or Linux Redhat 4 box. But when I am running the same on a HP Itanium 9 box, it is not able to run the sp. Please find attached the trace files in the two cases.
    Please let me know if I have missed something --- in the configuration / environment / DB .....
    Thanks in advance.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Invoke Stored procedure in HP Linux box

    Posted Thu October 23, 2008 12:41 PM

    Originally posted by: SystemAdmin


    Can you post the trace files in a text format. I can't read them.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Invoke Stored procedure in HP Linux box

    Posted Thu October 23, 2008 02:21 PM
      |   view attached

    Originally posted by: SystemAdmin


    Hi Rep,
    I will attach the two text files seperately
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender

    Attachment(s)

    txt
    attachment_14157107_trace_failed.txt   1 KB 1 version


  • 4.  Re: Invoke Stored procedure in HP Linux box

    Posted Thu October 23, 2008 02:22 PM
      |   view attached

    Originally posted by: SystemAdmin


    Pls find the other
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange

    Attachment(s)

    txt
    attachment_14157109_trace_Success.txt   1 KB 1 version


  • 5.  Re: Invoke Stored procedure in HP Linux box

    Posted Thu October 23, 2008 04:08 PM

    Originally posted by: SystemAdmin


    when are used oracle 9i ver8.1(37) adapter you could able to connect successfully.
    When you used ODBC ver 8.2(51) adapter you failed to execute the SP.

    Check the ODBC library version conpatibility with oracle version.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 6.  Re: Invoke Stored procedure in HP Linux box

    Posted Fri October 24, 2008 10:16 AM

    Originally posted by: SystemAdmin


    Nagesh, in our process we have MB also. We invoked the sp with MB and the same environment setup, it got executed successfully, returning the expected value. I think there is a problem running it with WTX on HP box.
    Can you please let me know if there is something else I need to look for.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 7.  Re: Invoke Stored procedure in HP Linux box

    Posted Fri October 24, 2008 11:35 AM

    Originally posted by: SystemAdmin


    I’ve never run a stored procedure from WTX, and I’ve only been on Unix for less then a year, but I didn’t think there was such a thing as an ODBC in Unix. Is there one on Linux?

    -1009 from what I’ve experienced usually points to a problem in the statement itself, such a lack of a value or missing quotes.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


Related Content