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@xxxxxxxxxxxxxx
> > [mailto:Ward.P.Fontenot@xxxxxxxxxxxxxx]
> > Sent: Monday, October 24, 2005 4:51 PM
> > To: csarnows@xxxxxxxxxxxxxx; dbi-users@xxxxxxxx
> > 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

.

Relevant Pages

  • Re: SQL and RPG
    ... the SQL statement is being called ... I don't need the semicolon token, ... ITMI in this example is 6 characters and ITP# is 18 ... If your fields are defined as character you have to put single quotes ...
    (comp.sys.ibm.as400.misc)
  • Re: Using Like operator in VBA
    ... a left bracket [inside the bracket pair to test whether the string ... text string in a SQL statement that you would want to test for? ... If YourVariable contains any of the wildcard characters that are used ...
    (microsoft.public.access.modulesdaovba)
  • Re: Viewing the contents of two tables using ASP and MS Access
    ... Number of fields in a recordset 255 ... Number of characters in a cell in the query design grid 1,024 ... Number of characters in an SQL statement approximately 64,000 ...
    (microsoft.public.inetserver.asp.db)
  • Re: Logn line
    ... characters for a compact index. ... It still may be your SQL statement length. ... It gave the error message: ... The maximum length for a command line has been exceeded. ...
    (microsoft.public.fox.helpwanted)
  • Re: No more space on line of code?
    ... Sorry Kevin, I guess I was a bit cryptic. ... >> Access MVP ... >>> point where it will no longer accept any more characters. ... >>> as best I know the SQL statement has to be all on one line. ...
    (microsoft.public.access.modulesdaovba)