You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » Some information about SP component
Post a reply
Topic review (newest first)
- 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
- 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
- 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 10:53:24
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