I created a simple test stored procedure with a weak REF CURSOR.
Specification:
TYPE LBCursorRef IS REF CURSOR;
PROCEDURE PR_TEST_WEAK_REF_CURSOR (
ICursor OUT LBCursorRef
);
Body:
PROCEDURE PR_TEST_WEAK_REF_CURSOR (
ICursor OUT LBCursorRef
)
IS
BEGIN
OPEN icursor FOR SELECT count(*)
FROM dual;
END PR_TEST_WEAK_REF_CURSOR;
When I run it through TOAD without printing anything, it works fine. But when I try to Print to DBMS Output I get an error. The Print option I am using is "Load into grid from memory (strong and weak)". And I get an error: "Connection is not defined"
On clicking 'Details' I get a popup with various tabs that were not helpful for someone with my amount of knowledge.
Any suggestions on what I can try will be much appreciated.
Thanks!
] 
Blog
Search
Help
Members
Register
Login
Home
