Re: [MLUG - DISCUSSION] Perl/Oracle question

["M. Kovalenko" <EMAIL:PROTECTED>]

"Ross, Matt" wrote:
> 
> I like perl, it's the DBD module that bugs me.
> Anyway, yes the table exists, yes the fields exist, and yes, there's data in
> them.
> 
> > -----Original Message-----
> > From: Michael [mailto:EMAIL:PROTECTED]
> > Sent: Thursday, January 03, 2002 5:56 PM
> > To: EMAIL:PROTECTED
> > Subject: Re: [MLUG - DISCUSSION] Perl/Oracle question
> >
> >
> > Obvious first question. Do you have a table or view by that name? ;)
> >
> > (I think this example proves why Perl is the spawn of the devil though
> > I've seen much much worse.. it's pretty good for Perl. *G*)
> >
> > > Ok, you asked for it!
> > >
> > > {> {> {> {> {> {>
> > > (ASCII pizza slices)
> > > ******************************
> > > Error Log:
> > > [Thu Jan 03 17:28:31 2002] [error] [client 168.166.168.104]
> > DBD::Oracle::db
> > > prepare failed: ORA-00942: table or view does not exist
> > (DBD: error possibly
> > > near <*> indicator at char 36 in 'SELECT distinct idnumber
> > > [Thu Jan 03 17:28:31 2002] [error] [client 168.166.168.104]
> >      FROM
> > > <*>cms_lq_link
> > > [Thu Jan 03 17:28:31 2002] [error] [client 168.166.168.104]
> >      WHERE
> > > qnumber = :QTYPE
> > > [Thu Jan 03 17:28:31 2002] [error] [client 168.166.168.104]
> >      AND answer
> > > = :ATYPE
> > > [Thu Jan 03 17:28:31 2002] [error] [client 168.166.168.104]    ') at
> > > d:\indigo\htdocs\demo2\NCDB_Q~4.PL line 146.
> > >
> > > *************
> > > Perl:
[snip]
> > > #
> > > # Trouble begins below...
> > > #
> > >
> > > $seegeeeye = 0;
> > > while ($seegeeeye < 13) {
> > >     print '???'.$cginumbers[$seegeeeye].'
> > > ???'.$q->param($cgiinputs[$seegeeeye]);
> > >   $qs = $db->prepare(
> > >    qq{SELECT distinct idnumber
> > >      FROM cms_lq_link
> > >      WHERE qnumber = :QTYPE
> > >      AND answer = :ATYPE
> > >    });
> > > # see, there be the prob...
> > >
> > >  $qs->bind_param(":QTYPE", $cginumbers[$seegeeeye] );
> > >  $qs->bind_param(":ATYPE", $q->param($cgiinputs[$seegeeeye]) );
> > >
> > > $qs->execute();
[snip]

Does is work from the command line? from within Oracle environment?

-- MK
--
To unsubscribe, go to http://mlug.missouri.edu/members/edit.php

Archives are available at http://mlug.missouri.edu/list-archives/