UTL_TCP: network problem ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: UTL_TCP: network problem ?

  1. #1
    Join Date
    Mar 2001
    Location
    Cologne, Germany
    Posts
    24
    Hi there,

    I'm using utl_tcp to establish a http-communication to webserver. (utl_http does not fit because I need the POST-Method to send XML)

    When I open the connection the first time and send data, reading raises utl_tcp.end_of_input, so I close the connection again. Works fine.
    Any following attempts using the same procedure (open/write/read/close) raise utl_tcp.network error when trying to read from the open connection.
    Rebooting the database resets the status, so I get end_of_input again for one time, then network_error.

    Is the utl_tcp.close_all_connections not releasing the connection ? Any Idea ?

    thanx in advance
    6502

    00 c0 LDA #'B'
    02 c0 STA $0400
    05 c0 LDA #'Y'
    07 c0 STA $0401
    0a c0 LDA #'E'
    0c c0 STA $0402
    0f c0 RET

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is your environment?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Location
    Cologne, Germany
    Posts
    24

    Smile

    Oracle 8.1.7 on HP.

    Communication works now. It was a network problem. My Firewall allowed the connection, but the counterpart firewall dropped it. utl_tcp has no specific exception telling me that the connection was closed by the foreign host. The end_of_input seems to be designed for it, but the package isn't really aware of the connection status.
    Using the 'Connection: Keep-Alive' feature of HTTP 1.1 causes my procedure to hang.
    The way it works allright is: open, send, read, close for every transaction, using HTTP 1.0 and 'Connection: Close'.

    There is one bug in the package, but it can be caught by exception.
    Starting my procedure the first time in a session raises
    'ORA-29531: No method get_crlf in class oracle/plsql/net/TCPConnection'
    'ORA-06512: in "SYS.UTL_TCP', Line 559

    6502
    00 c0 LDA #'B'
    02 c0 STA $0400
    05 c0 LDA #'Y'
    07 c0 STA $0401
    0a c0 LDA #'E'
    0c c0 STA $0402
    0f c0 RET

Posting Permissions

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



Click Here to Expand Forum to Full Width