Updated on 2023-10-23 GMT+08:00

DBE_PLDEBUGGER.turn_on

This function is used to mark a stored procedure as debuggable. After turn_on is executed, the server can execute the stored procedure for debugging. You need to manually obtain the OID of the stored procedure based on the PG_PROC system catalog and transfer it to the function. After turn_on is executed, the execution of the stored procedure in the current session is hung before the first SQL statement to wait for the debugging instruction from the debug end. This setting is cleared by default after the session is disconnected. Currently, stored procedures and functions with autonomous transactions enabled cannot be debugged.

The function prototype is as follows:

1
2
DBE_PLDEBUGGER.turn_on(Oid)
RETURN Record;
Table 1 turn_on input parameters and return values

Name

Type

Description

func_oid

IN oid

Function OID

nodename

OUT text

Node name

port

OUT integer

Number of the connected port