Problems with stored Procedure in Firebird

REST API
1

Hi:

I have several procedures in a database in firebird
I want to execute them with api docs, but they do not show,
I get the following error.

http://192.168.1.14/api/v2/ENVIOS/_proc/DOCTOS_VE_ORDEN_COMPRA

{
“error”: {
“code”: 404,
“context”: null,
“message”: “Procedure ‘DOCTOS_VE_ORDEN_COMPRA’ does not exist in the database.”,
“status_code”: 404
}
}

with curl
curl -X GET “http://192.168.1.14/api/v2/ENVIOS/_proc?refresh=true …”

the anwers is

{
“resource”:
}

thanks!!!

Best Regards.

3

Hi fantonio, could you solve the problem? I have the same issue. All my stored procedures or functions are not shown and when I call them, I receive the above shown message.

4

Hi,
I didn’t find a way in dreamfractory. but one way was to declare a view in Firebird and execute the stored procedure.
Create or alter procedure xxx_xxx return ( )
Begin
…
End
…

create View yyy_yyy ( ) as Select * from xxx_xxx;

The View Is visible un dreamfactory.

5

That might be a way. How did you manage to use one or more parameters?