Re: Can anyone shed any light on how to run a package in TOAD and return a recordset?

From: Martin Burbridge <pobox002_at_bebub.com>
Date: 9 Jan 2003 09:34:38 -0800
Message-ID: <45a06b65.0301090934.2d34d1ae_at_posting.google.com>


"Rubber Duck" <rubberducky703_at_hotmail.com> wrote in message news:<avjfv1$g3le4$1_at_ID-116287.news.dfncis.de>...
> Can anyone shed any light on how to run a package in TOAD and return a
> recordset?
>
> I've heard its not for the faint of heart, can anyone point me to any
> examples or suggest a better alternative?

In the better alternative category I'd suggest sqlplus:

SQL> var rc refcursor
SQL> exec :rc := demo_pkg.get_emp

PL/SQL procedure successfully completed.

SQL> print rc

 EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

------ ---------- --------- ------ --------- ------ ------ -------
  7369 SMITH      CLERK       7902 17-DEC-80    800             20
  7499 ALLEN      SALESMAN    7698 20-FEB-81   1600    300      30
  7521 WARD       SALESMAN    7698 22-FEB-81   1250    500      30
  7566 JONES      MANAGER     7839 02-APR-81   2975             20
  7654 MARTIN     SALESMAN    7698 28-SEP-81   1250   1400      30
  7698 BLAKE      MANAGER     7839 01-MAY-81   2850             30
  7782 CLARK      MANAGER     7839 09-JUN-81   2450             10
  7788 SCOTT      ANALYST     7566 09-DEC-82   3000             20
  7839 KING       PRESIDENT        17-NOV-81   5000             10
  7844 TURNER     SALESMAN    7698 08-SEP-81   1500      0      30
  7876 ADAMS      CLERK       7788 12-JAN-83   1100             20
  7900 JAMES      CLERK       7698 03-DEC-81    950             30
  7902 FORD       ANALYST     7566 03-DEC-81   3000             20
  7934 MILLER     CLERK       7782 23-JAN-82   1300             10

14 rows selected.

SQL> Martin Received on Thu Jan 09 2003 - 18:34:38 CET

Original text of this message