Updated on 2024-06-03 GMT+08:00

DBE_PLDEBUGGER.attach

When the server executes a stored procedure, the server hangs the execution before the first statement and waits for attaching with the debug end. The debug end invokes the attach function and transfers node name and port number to attach with the specified stored procedure, as described in Table 1.

If an error is reported during debugging, the attach operation automatically becomes invalid. If the debug end is attached to another stored procedure during debugging, the debugging of the attached stored procedure becomes invalid. If the attach operation is performed repeatedly, the current stored procedure is disconnected.

Table 1 attach input parameters and return values

Name

Type

Description

nodename

IN text

Node name.

port

IN integer

Connection port number.

funcoid

OUT oid

Function ID.

funcname

OUT text

Function name.

lineno

OUT integer

Number of the next line in the current debugging process.

query

OUT text

Source code of the next line of the function that is being debugged.