SQL Navigator
When executed a store procedure that retrieved some data, SQL Plus Users type the following command to get the data to display on the Screen:
SQL> set autoprint on
SQL> variable cv refcursor
SQL> execute package_name.procedure_name(:cv)
The output, which happens to be rows from a query from the procedure, is directed back into SQL*Plus and displayed for the user.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center