Skip to content


Are Stored Procedures supported with Smart View?

Lewis asked 11 months ago
Patrick Roth Staff answered 11 months 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.