Re: Procedures - Result Sets

From: Klaus Zeuch <KZeuch_at_hotmail.com>
Date: Thu, 4 Jan 2001 21:14:54 +0100
Message-ID: <932lmd$9tp$07$1@news.t-online.com>

I already answered your question 2 days ago: look at http://osi.oracle.com/~tkyte/ResultSets/index.html . It should be easy to modify the vb example given there.

Klaus
"Jeff" <jeff.cichocki_at_wgrfurniture.com> schrieb im Newsbeitrag news:932ej4$mev$1_at_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 - 14:14:54 CST