On Sun, 3 Nov 2002 22:11:25 -0600 (CST) Chuck Tomasi <[EMAIL PROTECTED]> wrote:
> This one has got us REALLY baffled. Standard logic is not applying. > > Scenario: Solaris 8, Oracle 8.1.7, Perl 5.6.1, DBI/DBD Oracle (versions > escape me at the moment, but their fairly up to date.) > bits::db::GetGroup(): select > ID,Name,Status,Members,Email,Feedback,FeedbackURL, > ReplyTo,Hours,UsesStatus,PriorityDue,Dispatcher,DispatcherAcct, > to_char(DateUpdated, 'MM/DD/YYYY HH12:MI:SS PM'),CcGroup from > BITS_ADMIN.BITS_GROUP where ID=1062 > > The code is pretty straight forward with a couple debug statements to see > output in the Apache error log file (as seen above.) > > Now for the kicker, if I'm opening a form (doesn't matter which of > multiple types of forms) for one location I get the message: > > [Thu Oct 31 14:11:25 2002] mk.misc.pl: DBD::Oracle::db prepare failed: > ORA-00921: unexpected end of SQL command (DBD ERROR: > OCIStmtExecute/Describe) at > /usr/local/lib/perl5/site_perl/5.6.1/bits/db.pm line 293. Have you tried using a placeholder instead of pasting the ID into the SQL? It sounds like the number is getting dropped some of the time. A placeholder would always be there, so it might avoid the problem. It would be more effecient anyway. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
