Home » SQL & PL/SQL » Client Tools » TOAD Error with weak REF CURSOR (TOAD 8.6.1.0, Windows XP SP2, Oracle 10)
TOAD Error with weak REF CURSOR [message #333422] Fri, 11 July 2008 11:10 Go to next message
agsharad
Messages: 10
Registered: August 2005
Junior Member
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!

Re: TOAD Error with weak REF CURSOR [message #334292 is a reply to message #333422] Wed, 16 July 2008 02:02 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

If you have an account at quest software, you can always check their knowledgebase

This error has been reported
Quote:
Error "Connection Is Not Defined" When executing a stored procedure that returns a ref cursor


And the solution
Quote:
This issue was fixed in Toad for Oracle 9.0.
Previous Topic: Connection to OMS Fails
Next Topic: How many lines of rows can be displayed through SQL PLUS
Goto Forum:
  


Current Time: Tue Dec 06 08:37:05 CST 2016

Total time taken to generate the page: 0.19665 seconds