No rows return from procedure - Unexpected EOF in prolog

[Anonymous]

Hi everyone again. I am new in Open Studio, so I have many questions
I created web-service, which calling stored procedure in Oracle and returns records set.
If my procedure returns even 1 row - everything is ok. But when the result is empty - there is a error (in attach).
What shall I do?
Thank you.

[Anonymous]

Hi, Gabriel, thanks for answer. I've just do like you, but how can you connect tFlowToIterate and tFixedFlowInput?
I can't do it...

[Anonymous]

Hi alexandr,
1. to connect tIterateFlow to tFixedInput there should be 'iterate' link available from the tFlowToIterate element
2. I wouldn't advice to fork the flow the way you did, I don't know the consequences if it works correctly, just start the lookup flow from the tOraceSP and in the paratemers you can use data passed into the tFlowToIterate element (ctrl-space to popup component elements in the parameter editor). The lookup flow will start when required.
good luck
Gabriel

[Anonymous]

Sorry, I can't do it... Too stupid, I think
The output columns from my stored procedure doesn't match with my input parameter. So I can't join it.
I think there will be a more easy way to resolve problem with 0 rows in output to xmlmap.... I think it is a standard and usual situation in web-services, isn't it?

[Anonymous]

Hm, I did something
I added tDie and connected it with tParseRecordSet with condition
((Integer)globalMap.get("tParseRecordSet_1_NB_LINE"))==0
Now, If oracle procedure returns 0 rows, I have a much more better XML output:
<FAULT>
<FAULTCODE>soap erver</FAULTCODE>
<FAULTSTRING>Talend job execution error</FAULTSTRING>
</FAULT>
And I have a question - can I set in <FAULTSTRING> other message? Something like 'no data found'.

[Anonymous]

Hi,
well - your data types should match in data flows..
you should use tEsbProviderFault instead of tDie component where you can specify the fault message..
gabriel