Procedures - Result Sets

From: Jeff <jeff.cichocki_at_wgrfurniture.com>
Date: Thu, 04 Jan 2001 18:15:10 GMT
Message-ID: <932ej4$mev$1@nnrp1.deja.com>

I had posted a message before regarding this topic, but I'm just not seeing the answer and I 'm running out of time to make this thing work.

I have all of my procedures working (in VB) except one. This is the only one that returns a result set. I can not get it to work. Could someone please help me fix the following procedure? I took out everything I did regarding cursors, as I don't seem to be able to grasp what I'm doing and I figured it would be easier to add than correct.

CREATE OR REPLACE PROCEDURE CUSTOM.UPS_EMPL   (HOME_STORE IN VARCHAR2) AS
    BEGIN

	SELECT EMP_CD, HPHONE EXT, COUNTRY STATUS
        FROM   MISC.EMP
        WHERE  HOME_STORE_CD = HOME_STORE
          AND  TERMDATE IS NULL
          AND  EMP_CD IN (SELECT EMP_CD
                          FROM EMP_SLSP)
	ORDER BY EMP_CD;

    END; Thanks to anyone who can help.

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 12:15:10 CST