The following procedure drops a connection identified by its connection number. Note that when executing the DROP CONNECTION
statement from within a procedure, you should do so using the EXECUTE IMMEDIATE statement, as shown in this example:
CREATE PROCEDURE drop_connection_by_id( IN conn_number INTEGER )
BEGIN
EXECUTE IMMEDIATE 'DROP CONNECTION ' || conn_number;
END;
The following statement drops the connection with ID number 4.