Is there a way to specify an alternate line terminator than a semicolon?
652774May 28 2009 — edited May 28 2009Hi,
This question came up in our SAS-L forum. SAS is supposed to pass a query like this to Oracle, but it isn't doing it right because it is looking at the semicolons first as a SAS delimiter:
proc sql;
CONNECT TO oracle (user=user password=password path=orcl);
execute(DECLARE a NUMBER := 3; BEGIN a := a + 1; END;) by oracle;
DISCONNECT FROM oracle;
quit;
This is a SAS error, not an Oracle error, on the first semicolon after the 3:
ERROR 79-322: Expecting a ).
Is there any way to specify a PL SQL line terminator to be something other than a semicolon?
-Mary