Talend community forum / Some information about SP component

jeremie · 2008-04-18 10:53:24

Tags: [component, database, mssql, mysql, oracle, sp, stored procedure, tos2.3.2]

Hi,

I want to have some explain from the tOracleSP or all SP component.

No problem with the configuration of Connection and the Schema.

We call the stored procedure or function in "SP name".

if "Is function" is marked, SP name are a function.

But i don't know how to use the "Parameters" and the "type" (IN, OUT, INOUT, RECORD SET)

Thank's for your explains

Jérémie

Uploaded Images

Olivier Carbone · 2008-04-18 11:57:51

Hi Jeremie !

Your questions are very general ... it's difficult to respond it! This component is described on the Components Guide: http://www.talend.com/resources/documentation.php

Can you reproduced the scenario include in this Guide and indicate in this forum the difficulties what you meet?

Thanks

jeremie · 2008-04-18 16:02:02

Thank you Olivier,

I have tested the scenario of the Gude component for the tMysqlSP (p. 214-)

I have juste an error if i use Id in the tRowGenerator

"
Starting job tMysqlSP at 16:00 18/04/2008.
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
row2.idState cannot be resolved or is not a field
row2.idState cannot be resolved or is not a field

at talenddemosjava.tmysqlsp.tMysqlSP.tRowGenerator_1Process(tMysqlSP.java:453)
at talenddemosjava.tmysqlsp.tMysqlSP.runJobInTOS(tMysqlSP.java:1405)
at talenddemosjava.tmysqlsp.tMysqlSP.main(tMysqlSP.java:1320)
Job tMysqlSP ended at 16:00 18/04/2008. [exit code=1]
"

If the change in idState no problem.

Thanks for some explain

Jérémie

shong · 2008-04-21 08:47:37

Hello

As the user guide documenation shows, define a procedure (it has a in paramter and a out paramter) in your database. When you define the schema of tMysqlSP, add a addtional column as output paramter column.(see the screenshot)

Best regards

shong

Uploaded Images

Announcement

Unanswered posts

#1 2008-04-18 10:53:24

Some information about SP component

#2 2008-04-18 11:57:51

Re: Some information about SP component

#3 2008-04-18 16:02:02

Re: Some information about SP component

#4 2008-04-21 08:47:37

Re: Some information about SP component

Board footer