Empty source when showing metadata of UDR (external Stored Procedure)

[tonne1]

Description

Metadata of UDRs (user defined routines) is not extracted, in this case metadata of external Stored Procedures.

DBeaver Version

Community Edition 24.0.5

Operating System

Win10, Win11

Database and driver

1. Firebird 4, Firebird 5
2. org.firebirdsql.jdbc:jaybird:RELEASE 5.0.4.java11

Steps to reproduce

Not as easy as with external stored functions, since there are no external stored procedures shipped with a Firebird installation. This system table query gives an idea of what to look for:

select trim(rdb$procedure_name) name, trim(rdb$engine_name) engine, trim(rdb$entrypoint) entrypoint
from rdb$procedures
where rdb$engine_name = 'UDR'

The outcome of metadata extraction should be something like this:

CREATE PROCEDURE WRITE_TXT (
    TEXT blob sub_type 1 NOT NULL,
    FILE_NAME varchar(500) NOT NULL,
    "MODE" varchar(10) NOT NULL )
RETURNS (
    STATUS varchar(100) )
EXTERNAL NAME 'pascaludr!write_txt' 
ENGINE UDR

similar to the extraction of external stored functions.

Additional context

No response

[E1izabeth]

Thank you for bug report.