Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error when load the data from oracle table to text file using odisqlunload tool in procedure

ARIVEMULA KAVYA KUMARI LERA TECHNOLOGY PVT LTDJul 23 2015 — edited Jul 25 2015

Hi Experts,

I have create a procedure. In that technology as "ODITOOL". Command is as follows

OdiSqlUnload "-FILE=C:\sample2.txt" "-DRIVER=oracle.jdbc.OracleDriver"

"-URL=jdbc:oracle:thin:@localhost:1521:user1"

"-USER=user1" "-PASS=welcome"

"-FIELD_SEP=;"

"-DATE_FORMAT=dd/MM/yyyy hh:mm:ss"

"-QUERY=select * from user1.DWT_COMPANY"

I want to load the data from orcle table DWT_COMPANY to sample2. txt file. When i execute the procedure , i am getting error like


"com.sunopsis.sql.SnpsMissingParametersException: ODI-30011: Parameter cannot be null:-URL"

Please help me.

Thanks in advance,

A.kavya.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2015
Added on Jul 23 2015
#11g, #business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration
9 comments
1,982 views