Can not insert data from temp table

[Former Member]

Hi all,

in HANA Studio i am trying to execute a procedure by calling the procedure with overview in order to fill a predefined column table with the procedure result.

Now when executing the procedure I get below error message in Log:

SAP DBTech JDBC: [1301]: numeric or value error: [1301] BIAPPL.CE_SQL_TEST2: line 15 col 2 (at pos 452): SQLException1301 exception

When i execute the same procedure call without passing the table name but NULL it will write it in a temp table where i can read then the data from.

Does anyone else already faced this issue?

BR,

Bastian

[lbreddemann]

Hello Bastian,

please provide the DDL for the procedure and the calc view that you're trying to build.

Also, it's always a good idea to mentioned what HANA revision you're using.

I just tried to create a script based calc view that runs a read/write stored procedure and correctly got this activation error (I edited in some line breaks to improve readability):

[...]

Internal deployment of object failed;
Repository: Encountered an error in repository runtime extension;
Internal Error:Deploy Calculation View:
SQL: transaction rolled back by an internal error:
EXPLAIN PLAN and CALL statement are not allowed:
CALL for non read only procedure/function is not supported in the READ ONLY procedure/function:

[...]

Based on your description of your requirements I assumed that you would have seen the same error.

Since you apparently had been able to deal with that, I wonder how your procedure looks like.

- Lars