Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question