SQL code_1: proc sql; connect to oracle (user="xxxxx" pw="%superq(ex_pw)" path="&ex_path"); execute (ALTER SESSION SET CURRENT_SCHEMA=HCCLNW;)by ORACLE; DISCONNECT from ORACLE; run; result_1: ERROR: ORACLE execute error: ORA-00922: missing or invalid option. SQL code_2: proc sql; connect to oracle (user="xxxxx" pw="%superq(ex_pw)" path="&ex_path"); execute (EXEC ALTER SESSION SET CURRENT_SCHEMA=HCCLNW;)by ORACLE; DISCONNECT from ORACLE; run; Result_2: ERROR: ORACLE execute error: ORA-06550: line 1, column 8:PLS-00103: Encountered the symbol "ALTER" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purgeThe symbol "update was inserted before "ALTER" to continue.ORA-06550: line 1, column 49:PLS-00103: Encountered the symbol ";" when expecting one of the following: ( begin case declare end exception exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purgeThe symbol "exit" was substituted for ";" to continue.. ANY IDEAs? Thanks.
... View more