My god... sorry, that got REALLY messed up while posting... Where did all my line-breaks go?

I'm trying to make a ruleset for Pro*C syntax. Pro*C is C run through Oracle's precompiler which allows you to embed SQL directly into C. I want to use the C mode and delegate the correct parts to the pl-sql mode.

The basic rules are:
Begin = "EXEC SQL CREATE" End = "END-EXEC;"
Begin = "EXEC SQL EXECUTE BEGIN" End = "END-EXEC;"
Begin = "EXEC SQL EXECUTE DECLARE" End = "END-EXEC;"
Begin = "EXEC SQL" End = ";"

The problem with these rules is that "EXEC", "SQL", "CREATE", "EXECUTE", "BEGIN", and "DECLARE" can all appear on separate lines and the delimiter for "EXEC SQL" is a ";" while the others are "END-EXEC;". I've tried creating separate rule sets, but I don't see a way to include a default case that changes the ending delimiter for the block.

I've also messed with regular-expressions via SPAN_REGEXP, but these only work on a single line at a time (which makes sense for speed) and can't just match the first character.

Any ideas?

Here's a snippit that I've been using for testing.

EXEC
SQL CREATE
select * from should_be_highlighted;
END-EXEC;
select * from should_NOT_be_highlighted;
EXEC SQL
EXECUTE select * from should_be_highlighted;
select * from should_NOT_be_highlighted;
EXEC SQL EXECUTE select * from should_be_highlighted;
select * from should_NOT_be_highlighted;
EXEC SQL select * from should_be_highlighted;
select * from should_NOT_be_highlighted;
EXEC SQL BEGIN DECLARE SECTION;
select * from should_NOT_be_highlighted;
EXEC SQL END DECLARE SECTION;
select * from should_NOT_be_highlighted;
EXEC
SQL
EXECUTE
BEGIN
select * from should_be_highlighted;
select * from should_be_highlighted;
END-EXEC;
select * from should_NOT_be_highlighted;
EXEC
SQL
select * from should_be_highlighted
;
select * from should_NOT_be_highlighted;
EXEC SQL EXECUTE BEGIN select * from should_be_highlighted;select * from should_be_highlighted;select * from should_be_highlighted;END-EXEC;
select * from should_NOT_be_highlighted;
EXEC SQL EXECUTE
BEGIN select * from should_be_highlighted;select * from should_be_highlighted;select * from should_be_highlighted;END-EXEC;
select * from should_NOT_be_highlighted;