Skip to content


Are Stored Procedures supported with Smart View?

Lewis asked 1 year ago
Patrick Roth Staff answered 1 year ago
SmartView doesn’t allow you to create any new reports – it just executes the “out of the box” GP SmartLists and then any you build with SmartList Builder.
From that standpoint, while SLB does let us use SQL in a query, you can’t validate an exec proc statement due to how it validates the SQL (to make sure you don’t have drop table or delete table, etc statements).
So no, I don’t see this as possible in either SV or SLB unless you possibly can get proc executed within a view.

If you would like to submit an answer or comment, please sign in to the eOne portal.