Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 13, 2015 at 07:24 AM

    Hi,

    Replying bit late, but look out this link for reference

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded