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
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
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
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) 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