Uso de variables en un query

[[duilioisola]]

Acabe de ver la documentación y dice <value> ::= A value of any type, as long as it's castable to a VARCHAR(255)
Por lo tanto la variable siempre es de tipo VARCHAR(255) y deberás hacer los CAST necesarios.

https://firebirdsql.org/refdocs/lang...t-context.html

Available in: DSQL, ESQL, PSQL

Added in: 2.0

Description: Creates, sets or unsets a variable in one of the user-writable namespaces USER_SESSION and USER_TRANSACTION.

Result type: INTEGER

Syntax:

RDB$SET_CONTEXT ('<namespace>', '<varname>', <value> | NULL)

<namespace> ::= USER_SESSION | USER_TRANSACTION
<varname> ::= A case-sensitive string of max. 80 characters
***
<value> ::= A value of any type, as long as it's castable to a VARCHAR(255)
***