Boolean in SAP HANA Stored Proceedure / SQL Script

[Former Member]

How to assign a boolean variable?

I can declare a variable as boolean. But neither can I assign 0 nor false to the variable 😮

I can active the procedure but the get error:

SAP DBTech JDBC: [7]: feature not supported: not supported constant type

Example:

Proceedure ....
  out isNumeric boolean)
...

isNumeric := false;

[lbreddemann · Accepted solution]

SQLScript logic blocks do not support BOOLEAN and IN/OUTPUT parameter types (check the documentation).

[Former Member · Accepted solution]

OK thx for pointing this out. It's confusing that the function get's activated though

[lbreddemann · Accepted solution]

Hmm... interestingly I got a more explicit error message indicating that boolean is not supported. What revision are you using here?

[SergioG_TX]

instead, please use int and assign 1/0