Skip to Content

Boolean in SAP HANA Stored Proceedure / SQL Script

How to assign a boolean variable?

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

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;
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 15, 2017 at 04:26 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2017 at 09:11 PM

    instead, please use int and assign 1/0

    Add comment
    10|10000 characters needed characters exceeded