Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best practice to make parametric selects?

user2081233May 30 2014 — edited Jun 4 2014

What is best practice to make parametric selects who's results will be later used in other stored procedures?

(As database evolves then selects can change to output the same data).

For know I use procedure that receive select's parameters and return a cursor with data. (These procedures mostly return cursors with data less than 100 rows.)

I do understand that it is possible to create a parametric views. Still, it requires to change this parameter in code and that can be omitted and lead to errors.

Is there some boundary on return data when you should definitely create a parametric view?

This post has been answered by Billy Verreynne on Jun 2 2014
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 2 2014
Added on May 30 2014
11 comments
4,022 views