Re: Didn't mean to ruffle any feathers

I didn't mean to cause a stink here. I was sitting in my office and was told I had to get data from our Oracle based ERP system 2200 miles away into my SQL Server by days end. I have no manuals and our firewall blocks port 80 (and getting that open would take an act of congress). So searching for help on the web is out. I do not have time to take classes or read books. I DO have usenet access so I used it. In doing so I chose the least restrictive group I could find - comp.databases.oracle.misc

In all my years utililizing the SQL server groups, never have I seen so many 'professionals' tell a person to take a class or read a book. In fact, the response that Vladimir left below is what I am used to. I realize full well that you do this because you want to not becasue you have to. Once again, you could simply have chosen to neglect the post completely.

Thank you Vladimir for your response. It was most helpful.

"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 Sat Jan 04 2003 - 11:53:15 CST