[Snort-devel] last_cid in new database scheme v106

Kreimendahl, Chad J Chad.Kreimendahl at ...1167...
Thu Sep 19 08:16:06 EDT 2002

Oracle limits not the length of the whole INSERT statement, but instead
the length of the values to 4000 bytes (not 4k).  Since we're using a
BLOB, this should (at least in 9i), allow for 4000 real bytes of data
(8000 characters).   However, I believe in 8 it is a hard 4000 length
limit no matter what the data type.

-----Original Message-----
From: Dirk Geschke [mailto:Dirk_Geschke at ...802...] 
Sent: Thursday, September 12, 2002 5:11 AM
To: Kreimendahl, Chad J
Cc: Dirk Geschke; snort-devel at lists.sourceforge.net;
Dirk_Geschke at ...802...
Subject: Re: [Snort-devel] last_cid in new database scheme v106 

What is the maximum query length on oracle? Maybe you should set
the constant in src/output-plugins/spo_database.c

#define MAX_QUERY_LENGTH 8192

to the right value?

More information about the Snort-devel mailing list