Re: Didn't mean to ruffle any feathers

I have read this thread with interest, looking at the differing viewpoints of all.

Not all of us Oracle guys are aggressive on this NG. I've been scanning the 3 main sets of the oracle newsgroups since i first started in 1996 (blimey time FLIES!!) under different NG aliases and it does seem that responses nowadays are more 'arrogant' than a few years back.

On the whole, most the flames occur when the original poster does not take the effort to read manuals or is trying to get their homework done. Only after reading near the end of the thread did we learn your situation (no manuals, net access and short deadline etc)

POSTERS: Try and do some research into your problem, RTFM before comming here. And remember http://metalink.oracle.com is awesome and 80% of the time will solve your problem.

REPLY-ERS: Calm down! Try to encourage folks to resources where they can learn more about problems and how they can help themselves, its annoying wading through posts of arguments and cusses. In the same way that we are not paid to participate on newsgroups, thus not wasting time to solve problems which are in user manuals, we shouldnt waste that same time writing a paragraph of text to slate someone. You'll give this NG a bad name (probably is already getting one). And if you dont like something, skip it and move on.

My TPW :-)

Happy 2003!

M

"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 Mon Jan 06 2003 - 08:49:21 CST