The GET_LINE procedure returns the text line data read until the end of the line or the end of the input.
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 true, the procedure removes one or more CRLF line break characters at the end of the line. |
| peek | If true, the procedure inspects the data but does not remove it from the input queue (an input buffer must exist). |
Return value
The text line data read.
Considerations
- The connection must have been opened by using the
open_connectionprocedure. - The procedure returns only when the end of the line or the end of the 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 procedure continues to wait for data packets until the timeout occurs, then stops reading and returns all successfully read data. If no data is successfully read, the
transfer_timeoutexception is raised.