The WRITE_TEXT procedure transmits text messages to a service over an open connection.
Applicability
This topic applies only to OceanBase Database in Oracle mode.
Syntax
UTL_TCP.WRITE_TEXT (
c IN OUT NOCOPY connection,
data IN VARCHAR2 CHARACTER SET ANY_CS,
len IN PLS_INTEGER DEFAULT NULL)
RETURN PLS_INTEGER;
Parameters
| Parameter | Description |
|---|---|
| c | The TCP/IP connection. |
| data | The buffer that contains the data to be sent. |
| len | The number of characters to be transmitted. If this parameter is NULL, all data is transmitted. Due to network conditions, the actual number of characters written may be less than the specified number. |
Return value
The number of characters actually transmitted.
Considerations
- The connection must have been opened by using the
open_connectionprocedure. - Convert the text character set to the specified online character set before transmission.
- If
lenexceeds the number of characters indata, thebad argumentexception is thrown.