The GET_LINE function returns the text line data that is read until the end of the line or the end of input is reached.
Applicability
This topic applies only to OceanBase Database in Oracle mode.
Syntax
UTL_TCP.GET_LINE (
c IN OUT NOCOPY connection,
remove_crlf IN BOOLEAN DEFAULT FALSE,
peek IN BOOLEAN DEFAULT FALSE)
RETURN VARCHAR2;
Parameters
| Parameter | Description |
|---|---|
| c | The TCP/IP connection. |
| remove_crlf | If this parameter is set to true, the function removes one or more CRLF line break characters at the end of the data. |
| peek | If this parameter is set to true, the function inspects the data without removing it from the input queue (an input buffer must exist). |
Return value
The text line data that is read.
Considerations
- You must have opened a connection by using the
open_connectionfunction. - The function returns only when the end of the line or the end of input is reached.
- The message text is converted from the online character set to the database character set when the connection is opened, and then returned.
- If a transfer timeout is set when the connection is opened, the function continues to wait for data packets until the timeout occurs. If the timeout occurs, the function stops reading and returns all the data that has been successfully read. If no data is successfully read, the
transfer_timeoutexception is raised.