-
Title
How to see data returned in RC2? -
Description
In SqlPlus, when querying 1st and 2nd RC using...
exec packag.proc(param1,param2,:rc1,:rc2);
print rc1
print rc2
Whilst the contents of RC1appears in Toad, how is it possible to see the data returned in RC2?
See below for example:
see sql statement:and see pacakge
CITDEV1(ABC)> @toad_test.pks
Package created.
CITDEV1(ABC)> @toad_test.pkb
Package body created.
The test can be re-created in SqlPlus as...
CITDEV1(ABC)> variable rc1 refcursor
CITDEV1(ABC)> variable rc2 refcursor
CITDEV1(ABC)> exec toad_test.get_data(:rc1,:rc2);
PL/SQL procedure successfully completed.
CITDEV1(ABC)> print rc1
1
----------
1
CITDEV1(ABC)> print rc2
2
----------
2 -
Resolution
WORKAROUND:
None
STATUS:
Enhancement request ER62923 has been submitted to Development for consideration in future release of Toad for Oracle. -
Defect ID
ER62923