How to see refcursor result/output in Oracle SQL Developer? [duplicate]

by

You can use a bind variable declared in SQL Developer to hold and show the results:

var r refcursor;
exec myPackage.mySPTest(P_NOTIFICATION_ID => 1975357, P_CURSOR => :r);
print r;

exec is shorthand for an anonymous block so this is equivalent to:

var r refcursor;
begin
    myPackage.mySPTest(P_NOTIFICATION_ID => 1975357, P_CURSOR => :r);
end;
/
print r;

Unless P_CURSOR is declared as something unhelpful, maybe…

More Related Contents:

  1. Printing the value of a variable in SQL Developer
  2. check if “it’s a number” function in Oracle
  3. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  4. Place to store PL/SQL block [closed]
  5. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  6. How can I set a custom date time format in Oracle SQL Developer?
  7. Get counts of all tables in a schema
  8. How to export query result to csv in Oracle SQL Developer?
  9. PL/SQL – Use “List” Variable in Where In Clause
  10. Convert timestamp datatype into unix timestamp Oracle
  11. How to avoid variable substitution in Oracle SQL Developer
  12. NLS_NUMERIC_CHARACTERS setting for decimal
  13. PL/SQL print out ref cursor returned by a stored procedure
  14. How to send email using Oracle 10 g Forms
  15. SQL Fiddle Output Error
  16. oracle PL/SQL how to calculate range ip for IPv6 cidr
  17. Trigger to enforce M-M relationship
  18. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  19. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  20. Oracle: how to INSERT if a row doesn’t exist
  21. Why are Oracle table/column/index names limited to 30 characters?
  22. Functions vs procedures in Oracle
  23. Reading clob line by line with pl\sql
  24. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  25. Why cannot I create triggers on objects owned by SYS?
  26. No more data to read from socket
  27. automating rollback script oracle
  28. How to test an Oracle Stored Procedure with RefCursor return type?
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment