alert tcp $EXTERNAL_NET any -> $SQL_SERVERS $ORACLE_PORTS (
msg:"GPL SQL dbms_repcat.make_column_group buffer overflow attempt";
flow:to_server,established;
content:"dbms_repcat.make_column_group"; nocase; fast_pattern;
pcre:"/((\w+)[\r\n\s]*\x3a=[\r\n\s]*(\x27[^\x27]{1075,}\x27|\x22[^\x22]{1075,}\x22)[\r\n\s]*\x3b.*(sname|oname)[\r\n\s]*=>[\r\n\s]*\2|(sname|oname)\s*=>\s*(\x27[^\x27]{1075,}|\x22[^\x22]{1075,})|\(\s*(\x27[^\x27]{1075,}|\x22[^\x22]{1075,})|\(\s*(\x27[^\x27]*\x27|\x22[^\x22]+\x22)\s*,\s*(\x27[^\x27]{1075,}|\x22[^\x22]{1075,}))/si";
reference:url,www.appsecinc.com/resources/alerts/oracle/2004-0001/25.html;
classtype:attempted-user;
sid:2102788; rev:4;
metadata:created_at 2010_09_23, confidence High, signature_severity Major, tag Description_Generated_By_Proofpoint_Nexus, updated_at 2019_10_08;
)