Hi,
I am trying to call oracle pl/sql procedure using OEDQ's Quick stat version i.e. 12.2.1.0.0.
I followed following steps:
- Created .sql file having code:
select * from dual;
exit;
/
-
After that created bat file which contains following code:
sqlplus.exe "oracleusername/password@servicename" @"C:\Program Files\Oracle\Enterprise Data Quality\director\12.2.1.0.0.(752)\oedq.local.home\commandarea\SAMPLE.sql
-
Placed above two files in following location:
C:\Program Files\Oracle\Enterprise Data Quality\director\12.2.1.0.0.(752)\oedq.local.home\commandarea
-
Created External task and called bat file:
However I am getting following error.
Appreciate your help on this.
Thanks,
Sheetal