Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Procedures - Result Sets

Re: Procedures - Result Sets

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 4 Jan 2001 23:23:00 +0100
Message-ID: <932t14$8o3bm$3@ID-62141.news.dfncis.de>

Try to *read* and *understand* the pages at the URL Klaus pointed you to. We are getting frustrated by people asking the same question over and over again, while the answer has been posted *numerous* time. We can't undertake to do your work for you. The *only* thing you need to do is to create a package with one type definition in it, and use that as a return type to your function. If you copy the second code fragment you should be set except for replacing the example statement with your statement. That is indeed *very* easy!

If you can't copy and paste that for the first few paragraphs of the page, how will you ever be an Oracle developer? Please forgive me this response, but you are just asking for it by answering in the way you did. We did help you out, and in turn we are being flamed. This whole discussion could have been prevented many times, if people would at least *try* to search Deja.cpm.

Regards,

Sybrand Bakker, Oracle DBA

"Jeff" <jeff.cichocki_at_wgrfurniture.com> wrote in message news:932og0$vsi$1_at_nnrp1.deja.com...
> I know that you pointed me to that web site two days ago, but my
> problem isn't on the VB side. It's in the procedure that I'm trying to
> create. I can't seem to get the syntax correct to even get it to
> compile. If I can get the procedure to work, I'm sure I can make the
> leap in VB to retrieve it.
>
> Please excuse my frustrated tone. I'm getting extremely frazzled by
> this project, and I'm almost out of time. This one procedure is start
> of all others. Without it, the whole project is useless.
>
> In article <932lmd$9tp$07$1_at_news.t-online.com>,
> "Klaus Zeuch" <KZeuch_at_hotmail.com> wrote:
> > 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/
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 04 2001 - 16:23:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US