How to execute a procedure in a package ? (newbie)

From: Long Pham <long.pham_at_ips-sendero.com>
Date: 24 Sep 1998 18:29:17 GMT
Message-ID: <6ue31t$5o1$1@oak.prod.itd.earthlink.net>

Hi,

I have the following package defined :

CREATE OR REPLACE PACKAGE Customers
AS

	TYPE tcus_nbr IS TABLE OF VARCHAR2(20)
	INDEX BY BINARY_INTEGER;
	TYPE tful_nme IS TABLE OF VARCHAR2(35)
	INDEX BY BINARY_INTEGER;
	TYPE ttin IS TABLE OF VARCHAR2(9)
	INDEX BY BINARY_INTEGER;

	PROCEDURE allcusts
		(cus_nbr OUT tcus_nbr,
		 ful_nme OUT tful_nme,
		 tin OUT tTin);

END Customers;

CREATE OR REPLACE PACKAGE BODY Customers AS

      PROCEDURE allcusts
                  (cus_nbr  OUT     tcus_nbr,
                   ful_nme  OUT     tful_nme,
                   tin      OUT     ttin)
      IS
          CURSOR customer_cur IS
                  SELECT CUS_NBR, FUL_NME, TIN
                  FROM CUST;

          custcount NUMBER DEFAULT 1;

      BEGIN
          FOR singleperson IN customer_cur
          LOOP
                  cus_nbr(custcount) := singleperson.cus_nbr;
                  ful_nme(custcount) := singleperson.ful_nme;
                  tin(custcount)     := singleperson.tin;
                  custcount := custcount + 1;
          END LOOP;
      END;

END; How do I go about executing the allcusts procedure from the command line in SQLPlus ? Any reply will be much appreciated. Thanks.

Long Pham Received on Thu Sep 24 1998 - 13:29:17 CDT