RE: Newline inserted?

I'm assuming that those characters are part of the text. I assume the last
text field is:
'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;'

This way the SQL statement ends like:
'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;')

The interpreter doesn't know which ') to stop at.

matt.

On Mon, 24 Oct 2005 16:59:17 -0400, Ronald J Kimball wrote
> The problem, as a couple people have already pointed out, is the semicolon.
>
> (There is no problem with newlines or single quotes here.) The semicolon
> after a statement is SQL*PLUS syntax. It is not valid in DBD::Oracle.
>
> Ronald
>
> > -----Original Message-----
> > From: Ward.P.Fontenot@wellsfargo.com
> > [mailto:Ward.P.Fontenot@wellsfargo.com]
> > Sent: Monday, October 24, 2005 4:51 PM
> > To: csarnows@pcbi.upenn.edu; dbi-users@perl.org
> > Subject: RE: Newline inserted?
> >
> > Syslog-ng is writing those sql insert statements for us, we just pick them
> > up, make a sha1, base64 encode that and then sign it with a digital
> > certificate and insert the whole thing into Oracle.


--
@@@USER@@@
Internet Channel -- inch.com

RE: Newline inserted?

Matthew Dougerty [mailto:mdougher@inch.com] wrote:
>
> I'm assuming that those characters are part of the text. I assume the
> last
> text field is:
> 'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;'
>
> This way the SQL statement ends like:
> 'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;')
>
> The interpreter doesn't know which ') to stop at.

No, the last field is 'H4vgmf+OJsT99kCfQuIpALY7k9k='. The final single
quote is part of the error message.

DBD::Oracle::st execute failed: ORA-00911: invalid character (DBD ERROR:
error possibly near <*> indicator at char 238 in 'INSERT INTO
message(FULLDATE,HOSTNAME,FACILITY,PRIORITY,MESSAGE,SHA1)
VALUES('2005-Oct-18
11:53:21','pkitest.wellsfargo.com','auth','info','su(pam_uni x)[3638]:
session opened for user oracle by
root(uid=0)','H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;')


Ronald