Tibco call Stored Procedure (date parameter) memo

Tibco version is 5.5

1. tibco calls the stored procedure of the database. If the type of parameter A is date and the value passed to parameter A is a Null String, an error of input data invalid is reported.

This is because parameter A requires a date parameter, even if it is a null string or null!

To solve this problem, you can createOptional's date variable BYou do not need to assign any value to this variable. You need the B type of this variable.

Judge whether the value passed to parameter A in the stored procedure is null. If it is null, assign variable B to parameter A because variable B is of the date type, there will be no input data invalid problem.

PS: Pay attention to the statement settings of parameter A. Generally, the icon of parameter A is as follows (there is a red circle in the lower right corner). If not, edit the statement of parameter A and click, edit the statement of parameter,
For example:

Another processing method: If this field is not necessary, we can add a "If judgment" on it, as shown in

In "If judgment", the system checks whether the parameter is null, whether the value of Count (parameter) is greater than 0, or whether the value of string-length (parameter) is greater than 0.

Then you can directly enter parameters or convert parameters with no scrubs.

2. tibco calls the stored procedure of the database. There is a bug in the timeout setting. If the setting exceeds 6 seconds (this time is still to be verified), it is invalid.

• If timeout is set to 4, the execution of the stored procedure is 5 seconds, and a timeout exception is thrown.
• If timeout is set to 6, the execution of the stored procedure is 5 seconds,ProgramSmooth execution.
• If timeout is set to 6 seconds and the stored procedure is executed for 7 seconds, the program gets stuck.
• If timeout is set to 10 seconds and the stored procedure is executed for 7 seconds, the program runs smoothly.
• If timeout is set to 10 seconds and the stored procedure is executed for 15 seconds, the program gets stuck.
• If timeout is set to 20 seconds and the stored procedure is executed for 15 seconds, the program runs smoothly.

Let's not talk about anything else. In a word, the larger the value of timeout, the better. You don't have to count on timeout settings.