Re: Didn't mean to ruffle any feathers

Hey There,

I had an issue too when I posted a question a few months ago. People got real agro and spent more time chastising me rather then simply answering the question. Chalk it up to people with nothing else going on in their life except for this, and, in the end, feel sorry for them. Don't worry though, there are some cool people here who will eventually answer your question.

: )

Mike

"George" <junk_at_ixsis.com> wrote in message news:<jCtR9.553405$P31.188196_at_rwcrnsc53>...
> I didn't realize you Oracle guys were so aggressive in your responses. If
> you don't want to help, just don't. I would rather not have a post responded
> to then get your pompus attitude. Thank you (and Ed ) for your help
> thusfar. I will make sure to not post here for help in the future.
>
> I'm sorry I missed the post declaring that usenet was suddenly for experts
> only.
>
>
>
> "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3E162E23.87CEBC4C_at_exesolutions.com...
> > George wrote:
> >
> > > Wonderful! Thanks
> > >
> > > Now this opens a whole new can of worms for me.
> > >
> > > The first one to come to mind is the select * statement. I am assuming
> that
> > > this can be a lengthy operation if the table has many fields and
> modifying
> > > the table later would rise cause to modify all procedures that contain a
> > > select * from the modified table.
> > >
> > > Also how then does the procedure return records to the client, or does
> it
> > > not? I then surmize that using procedures to return records to the
> client is
> > > might not be the prefered method but rather a view?
> > >
> > > "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> > > news:3E15BA0A.EC90F173_at_exesolutions.com...
> > > > George wrote:
> > > >
> > > > > I am coming from a SQL Server background so be gentle...
> > > > >
> > > > > I am trying to get this simple procedure worked out and it compiles
> invalid.
> > > > > What am I doing wrong
> > > > >
> > > > > BEGIN
> > > > > SELECT SSN FROM STUDENT;
> > > > > END;
> > > >
> > > > You must SELECT into something.
> > > >
> > > > PL/SQL is a server language not a client language.
> > > >
> > > > So you SELECT statement slelects the value into nothingness.
> > > >
> > > > Try this:
> > > >
> > > > DECLARE
> > > >
> > > > x student.ssn%TYPE;
> > > >
> > > > BEGIN
> > > > SELECT ssn
> > > > INTO x
> > > > FROM student;
> > > > END;
> > > > /
> > > >
> > > > Daniel Morgan
> > > >
> >
> > We don't run an Oracle tutorial service here on the usenet. You need to go
> to
> > your local bookstore or take a class.
> >
> > Ed gave you a good answer for returning multiple rows inside a procedure
> but
> > not necessarily for returning them to a front-end program. You need to use
> > http://tahiti.oracle.com to look up your questions before coming here for
> tips
> > when you get stuck. To get you started on this one look up "REF CURSOR".
> >
> > Daniel Morgan
> >
Received on Tue Jan 07 2003 - 13:33:35 CST