Hi,
Thanks for reply. Yes you are right. it seems some setting need to update. but not sure where we can update it. Normally we can run Script in SQL plus but not through sas. I am getting below error. tried so do settings for ORACLE_HOME but still same issue. I have checked macro variables give correct values as we creat macro variables in same code.
Stderr output:
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
NOTE: DATA statement used (Total process time):
real time 0.32 seconds
cpu time 0.01 seconds
... View more