I read the "I don't have time" excuse as "my time is more important than
your time". Which is I think the point some people are trying to make. (no
it isn't) Also the manuals should be available on the CD that came with the
product. Mine always was. I have been doing this for years and I still
refer to the manuals and other books to get my job done. I read all the
time; it is part of the job.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"George" <junk_at_ixsis.com> wrote in message
news:fcFR9.561808$P31.191578_at_rwcrnsc53...
> 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 - 13:31:00 CST
