[resolved] How can Talend execute an Oracle pl/sql script?

One Star

[resolved] How can Talend execute an Oracle pl/sql script?

Hi,
I have a complex pl/sql script to execute at the end of a migration process. this process being handle by Talend, I would like that the execution of the script is also handle by Talend.
I tried to use tOracleRow without success.
In the query part I directly paste the pl/sql (between double quotes) and get the following error:

connecting to socket on port 4034
connected
ORA-06550: Ligne 1, colonne 382 :
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<identificateur> <identificateur entre guillemets>
<variable attachée (bind variable)> << continue close
current delete fetch lock insert open rollback savepoint set
sql execute commit forall merge pipe purge
disconnected
Job test_oracleELT terminé à 08:05 07/09/2012.
How can this issue be solved?
I'm using Talend Data Integration 5.0.2r78327
Cheers,
Sebastien

Accepted Solutions
One Star

Re: [resolved] How can Talend execute an Oracle pl/sql script?

Problem solved.
The issue was due to there was Oracle comments in the script.
The following example shows a solution. It supposes that there is a table TOTO is the schema.
Don't forget to check the "Die on error" option to catch Oracle exception as an error.

All Replies
One Star

Re: [resolved] How can Talend execute an Oracle pl/sql script?

Problem solved.
The issue was due to there was Oracle comments in the script.
The following example shows a solution. It supposes that there is a table TOTO is the schema.
Don't forget to check the "Die on error" option to catch Oracle exception as an error.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now