SAP Hana PAL Algorithms in a Stored Procedure. How to?

[Former Member]

I've been trying to create a Stored procedure to define, create and call a PAL algorithm inside a *.hdbprocedure.

But my code gives an error in this line:

CALL SYSTEM.AFL_WRAPPER_GENERATOR ('PAL_KM', 'AFLPAL', 'KMEANS', PAL_KM_SIGNATURE);

"Could not create catalog object: feature not supported; Only table variable is allowed in input parameter in a nested call: line 61 col 66 (at pos 3427)"

I saw in other discussion that the problem may be caused by the fact that I create the table in the same stored procedure thus the table doesn't exist by the time it makes the call, so I tryied adding a COMMIT statement but it's not allowed and gives syntax error, I saw somewhere else that I could do an exec 'COMMIT', but this threw me back to the first error.

I also tried creating that table outside the stored procedure and only making the call, but it's the same issue.

I would appreaciate any help about this issue.

Thanks in advance.

[Former Member]

Hi,

Replying bit late, but look out this link for reference

Thanks,