in reply to Re: Searching for paragraphs but trickyin thread Searching for paragraphs but tricky
Hence the question. :)
Anyway, there's nothing wrong with your syntax as this trivial example demonstrates:
$ echo -e "CREATE TABLE WCC.CONTACT\nfoo\n;\nCREATE TABLE WCC.CONTACTM +ETHOD\nbar\n;\n" | perl -ne 'print if /CONTACT$/ .. /;/;' CREATE TABLE WCC.CONTACT foo ; [download]
Therefore the obvious conclusion is that your input file does not contain what you think it contains. Use a hexdump to see what's actually in there.