Skip to Content

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

Procedure with result view

Hi,

I successfully created a procedure with the .hdbprocedure syntax. Now I wanted to add a result view to this procedure (which has only one output parameter) as described in the SQLScript Reference Guide. Unfortunately I always get the simple error message "The With Result View statement is not permitted". We are using HANA revision 96.

Are there any restrictions for using result views in procedures which the reference guide does not mention? The strange thing is that even the simple result view example as described in the guide does not work in my case.

Additional question:
Is it possible to generate an oData service on top of the result view of a procedure and in that way consume this procedure in a UI5 application?

Thanks and best regards

Felix

Tags:
Former Member
replied

You should use a table UDF(.hdbtablefunction) for this requirement instead. There is no plans to support WITH RESULT VIEW in .hdbprocedure

Cheers,

Rich Heilman

SAP HANA Product Management

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question