i finished a anomaly detection which is working fine within a SQL console. To use this script i want to copy my sql pal script into a procedure, but it's more difficult then i thought it would be.
Many operators like drop type, truncate table and so on are not allowed in a procedure. Now i am asking myself:
1) Is a procedure the best way to use the sql pal script in a sapui5 frontend?
2) If yes, how to avoid the issues caused by the procedure or
how to transfer the sql script easliy into a procedure?
3) If no, what would be a better way?