This content has been marked as final. Show 5 replies
lony wrote:Use OdiSqlUnload tool to write the output of the sql query to a file
I am using ODI 11g.
In ODI I want to write the output of the below query to a unix file.
SELECT 'H'|| rpad('SB9KT.KTPRTO.EBSDATA.D0000000','30',' ')|| rpad(to_char(sysdate, 'YYYYMMDDHHMMSS'), 16, ' ')
Please suggest any inputs.
But what are the parameter we need to pass on .
Do we need to pass all the parameter?
Lony, See the examples given here http://gerardnico.com/doc/odi/webhelp/en/ref_tools/snpssqlunload.html1 person found this helpful
and you can also refer http://odiexperts.com/calling-odisqlunload-using-odi-procedure-with-no-hardcoded-password/
i am getting the below error.
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character