How to test an Oracle Stored Procedure with RefCursor return type?

by

Something like

create or replace procedure my_proc( p_rc OUT SYS_REFCURSOR )
as
begin
  open p_rc
   for select 1 col1
         from dual;
end;
/

variable rc refcursor;
exec my_proc( :rc );
print rc;

will work in SQL*Plus or SQL Developer. I don’t have any experience with Embarcardero Rapid XE2 so I have no idea whether it supports SQL*Plus commands like this.

More Related Contents:

  1. Place to store PL/SQL block [closed]
  2. Fetch Oracle table type from stored procedure using JDBC
  3. Passing an array of data as an input parameter to an Oracle procedure
  4. What is the difference between “AS” and “IS” in an Oracle stored procedure?
  5. Oracle stored procedure with parameters for IN clause
  6. Get resultset from oracle stored procedure
  7. oracle PL/SQL how to calculate range ip for IPv6 cidr
  8. Functions vs procedures in Oracle
  9. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  10. oracle “table or view does not exist” from inside stored procedure
  11. Reading clob line by line with pl\sql
  12. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  13. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  14. How to View Oracle Stored Procedure using SQLPlus?
  15. Printing the value of a variable in SQL Developer
  16. Convert comma separated string to array in PL/SQL
  17. UTL_FILE.FOPEN() procedure not accepting path for directory?
  18. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  19. NLS_NUMERIC_CHARACTERS setting for decimal
  20. Formatting DATE in oracle
  21. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  22. Best practice for pagination in Oracle?
  23. check if “it’s a number” function in Oracle
  24. ORA-12170: TNS:Connect timeout occurred
  25. How to create and use temporary table in oracle stored procedure?
  26. SQL*Plus how to accept text variable from prompt?
  27. How to find difference b/w TIMESTAMP format values in Oracle?
  28. How to find out when an Oracle table was updated the last time
  29. NLS_LANG setting for JDBC thin driver?
  30. How do I get column datatype in Oracle with PL-SQL with low privileges?

Leave a Comment