How do you write a wrapper for PRXMATCH for FEDSQL?

[tomcmacdonald]

I can't get past this seemingly trivial exercise.  I would like to take advantage of all that PROC FEDSQL has to offer but simply cannot get consistent use of a PROC DS2 package.

PROC DS2;
	package regexp / overwrite=yes;
		method match( varchar(1024) pattern, varchar(1024) string ) returns integer;
			return prxmatch(pattern, string);
		end;
	run;
QUIT;

Seems to yield the cryptic and not very useful error message of

ERROR: Access Violation occurred during PREPARE!

When trying to use it here for instance

PROC FEDSQL;
	INSERT INTO tableB
	SELECT id 
	FROM tableA
	WHERE 
		regexp.match('/.*/', id) = 1 
		AND regexp.match('/^[5-9]/', id) = 0;
QUIT;

Like are these PROC DS2 packages simply broken when used with PROC FEDSQL and I should just wait until 9.5 to come out when SAS has hopefully fixed all the bugs?  Is this thing just inherently buggy?

[tomcmacdonald]

Anyone?  Would truly love to use this feature but cannot unless I have full PRXMATCH functionality.