[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.