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.
1(a). From DB Navigator tree highlight the package or procedure OR
1(b) Load the package or procedure into Store Program Editor Window
2. Hit F9 or RH mouse click "Execute...",
3. Execution Code Wizard will appear, click Next
4. Set ON "Create new code" and click Next,
5. Skip Profiling and click Next,
6. In "Set Options" tick a box "Use bind variables to pass arguments and display results in a grid", and click Next,
7. In "Preview" click Next,
8. In "Results" window you will see the following:
__________________________________
|p_recs_cursor | (Cursor) |
9. Click on (Cursor} field and the box similar to this one |...| will appear on the right side of the field,
10.Click on this combo box and Query Results window will appear.
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center