My database is oracle I want to know creating procedure is good or I will use framework manager to get the information which is required my reporting. I mean to say is there any advantages to create procedure at database level or I will create the attribute at FM. I never create procedure that's why I want to know.
The primary reason for creating a database procedure is that you need some sort of non-set based logic (procedural logic) which does not 'fit' into FM. If you can fetch the data through regular expressions within the framework, then a DB Procedure may you mean just overhead. (as in worse performance and unwanted complexity)