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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center