We are changing our db from MSSQL to HANA and during our development we came across some difficulties.
Some background: My application is written in .net (using ado.net to connect to HANA). It also has spatial data (st_geometry hana-type) that I publish
1. ALM - I understand that I can use HALM for object transfer between environments (dev, test, prod). I created my objects with sql scripts (Create table.. Create procedure.. etc) - According to what I read, I can't use HALM for this kind of objects. How do I need to create my objects (tables, views, procedures) and what options do I have to transfer my objects between environments? (notice, I'm using spatial data too)
2. Stored procedure input parameters:
CREATE PROCEDURE SP_EXAMPLE(IN INPUT_PARAM BOOLEAN) AS.....
But when I try to call it:
We get an exception - "Feature not supported: no supported constant type". How can I call SP's with a boolean parameter?