loading cvs file into oracle table

One Star

loading cvs file into oracle table

Hi !
Well i read your documentation i try to load an simple CVS file into Oracle 10g database, i can't.
I know i'm a rookie.
Well, i create a job, an tFileInputDelimited and tOracleOutput objects.
I click on Edit schema. I ran the job and .. nothing !
Must i use tMAP to translate file fields into Oracle table ?
thx for your answer.
__________________________________________________________________________________________________
Under Windows XP
TOS:v2.1.0.M1_r3483
Oracle 10g
jre 1.6
Community Manager

Re: loading cvs file into oracle table

Hi,
you should not need tMap to insert data into a DB, unless you want to transform data beforehands.
Does your job starts and ends properly? The Run Job view should display standard messages. See screenshot.
We miss information about TOS version, Java or Perl...
What happens then on the DB side? nothing?
As you use tFileInputDelimited, mind the length of your schema columns as it should take into account the double quotes (if any are used in your csv file)
I didn't get any issue to feed it with csv data.
Elisa
Employee

Re: loading cvs file into oracle table

Hi,
Can you verify that you have specified a Schema in your tFileInputDelimited component ?
Regards.
One Star

Re: loading cvs file into oracle table

Hi everybody !
Here is my error
ORA-936 ... Of what kind expression does he want to speak ???
I create tFileIputDelimited (schema typre repository ...) and
tOracleOutput (schema type repository).

___________________________________________________________________
Starting job job_1 at 15:12 27/06/2007.
Exception in component tOracleOutput_1
java.sql.SQLException: ORA-00936: expression absente
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
at projet_1.job_1.job_1.tFileInputDelimited_1Process(job_1.java:451)
at projet_1.job_1.job_1.main(job_1.java:596)
Job job_1 ended at 15:12 27/06/2007.
___________________________________________________________________

Elisa: ... Under my post i specified my configuration ;o) I not use perl.
thx all
Community Manager

Re: loading cvs file into oracle table

It looks like the second and third screens are the same. Can you post the FileDelimited Properties settings screen?
trying to reproduce.
Elisa
Employee

Re: loading cvs file into oracle table

Can you attach the code generated (code tab) ?
Michaël.
One Star

Re: loading cvs file into oracle table

Hi all
Yip yip hurra, my job work looool.
I delete my job and make again.
i named all columns file like columns table, they was differents.
well,
thanks for and to all.
I have an other question ...
I have 2 columns in "float" type in my file,
I declared 2 columns in "float" type and i declared the same in the table
I ran and my job down.
I must declared the both in "String" type and then my job ran.
I don't figure out this behaviour and especially this logic ????? (I don't find the anger smiley) Smiley Tongue
My Oracle Table:
CREATE TABLE VENTES
(
PROD_ID NUMBER NOT NULL,
CUST_ID NUMBER NOT NULL,
TIME_ID DATE NOT NULL,
CHANNEL_ID NUMBER NOT NULL,
PROMO_ID NUMBER NOT NULL,
QUANTITY_SOLD NUMBER(10,2) NOT NULL,
AMOUNT_SOLD NUMBER(10,2) NOT NULL
);
and the "Edit schema" in the picture.
best regards
and thx Smiley Very Happy