topic Re: [resolved] Oracle sequence while insert. in Talend Studio

[resolved] Oracle sequence while insert.

Anonymous — Sat, 16 Nov 2024 14:32:19 GMT

Hi,
Anybody has an experience to use oracle sequence while inserting. what is the way to get the sequence which is defined in oracle to use with TOS database components?
regards,
sebastianr

Re: [resolved] Oracle sequence while insert.

Anonymous — Fri, 19 Oct 2007 15:14:25 GMT

Hello,
Use the additional columns table.
Regards,

Re: [resolved] Oracle sequence while insert.

Anonymous — Sun, 21 Oct 2007 12:49:43 GMT

Dear Mhirt,

Using "Additional Columns" option, how can use oracle sequence? I dont want generate the numbers in TOS itself. I need to get the sequence which is defined in Oracle and increment the value while inserting.
For eg. insert into employee (EMP_SEQ_ID, EMP_NAME) values(EMP_SEQ.NEXTVAL, 'Sebastian');
Here i am using Oracle sequence EMP_SEQ. Same way i want it to be done.
If your reply addressed my query, how can it be achieved with "Additional Columns" option.

Thanks.

Re: [resolved] Oracle sequence while insert.

Anonymous — Sun, 21 Oct 2007 20:59:30 GMT

Additional Columns are designed to handle db columns which needs instructions but where there are no datas from the row.
In your component schema, you have EMP_NAME.
Configure additional column like in the picture added.

Regards,
Michaël.

Re: [resolved] Oracle sequence while insert.

Anonymous — Thu, 26 Jun 2008 13:39:54 GMT

Hello,
I have a problem using an oracle sequence to get value for my primary key.
I added an additional column but it doesn't work
there you ca find all screenshot.
The error is in english "sequence number not allowed here"
I hope that you can help me
Thx

Re: [resolved] Oracle sequence while insert.

Anonymous — Thu, 26 Jun 2008 15:03:36 GMT

OK I've changed the SQL expression in my tOracleOutput additional column to "select hibernate_sequence.nextval from dual" and now a new error seems to appear :"ORA-00936: emissing expression"
Is it better or worst?

Re: [resolved] Oracle sequence while insert.

Anonymous — Thu, 26 Jun 2008 16:21:30 GMT

I'm really sorry but my issue comes from my sql expression. In fact the right expression is "hibernate_sequence.nextval" and now all works fine
thx

Re: [resolved] Oracle sequence while insert.

Anonymous — Thu, 29 Apr 2010 18:25:16 GMT

I'm really sorry but my issue comes from my sql expression. In fact the right expression is "hibernate_sequence.nextval" and now all works fine
thx

Hello all,
when I type this, I've got the next error: java.sql.SQLException: ORA-02287: sequence number not allowed here
Please, could you help me.
Thanks in advance,
Gracia.

Re: [resolved] Oracle sequence while insert.

Anonymous — Mon, 03 May 2010 17:12:27 GMT

I'm really sorry but my issue comes from my sql expression. In fact the right expression is "hibernate_sequence.nextval" and now all works fine
thx

Hello all,
when I type this, I've got the next error: java.sql.SQLException: ORA-02287: sequence number not allowed here
Please, could you help me.
Thanks in advance,
Gracia.
I've found the problem: I can't use the sequence over a Key Field.
Thanks,
Gracia.

Re: [resolved] Oracle sequence while insert.

Anonymous — Mon, 16 Aug 2010 12:11:21 GMT

Hi,
this call of sequence work fine when you use the column name in upper format

Re: [resolved] Oracle sequence while insert.

_AnonymousUser — Wed, 27 Jan 2016 18:59:01 GMT

So can we not do this with the primary key columns in the table? We are using Talend Data Mapping to map our XSD's to tables in our Oracle database and are trying to find out ways to get the primary keys and foreign keys.
thank you