CALL STORED PROCEDURE, STRING PARAMETER VALUES ARE LOST

[Sedat_Reyhan]

Hello,

I need really urgent and critical help!

After a user completes the task in workspace (fills a form), there is a "Call Stored Procedure" operation.

This operation passes 85 piece of INT and STRING parameters to a procedure in Oracle db

(parameter values are from the form-xpath- that the user filled in ws).

The problem is: String values are mostly seen as emty values, but sometimes not!

When i tested it first time, all values (85 piece) are ,nserted to the db, but in the second time and later, non of the string values are inserted into the db.

Could you advice pls?

Best regards,

Sedat Reyhan

[Jasmin_Charbonn]

Any error in the logs?

Jasmin

[Sedat_Reyhan]

No error Jasmin, unfortunately no.

When i first run it, all the values in the form inserted by the proc. Immediately after that-without changing anything- i run it, and only INT types are inserted, strings not. And then after, sometimes inserted sometimes not-for instance, i changed one parameter's type to INT from string, it inserted a zero(0).

[Sedat_Reyhan]

I have found something else about the problem:

After i alter the Oracle table (for instance-change a column's type), all columns are updated by the call procedure opertion.

(Values are coming from a xfaForm as parameters). But second time after altering the table, again only int fileds are updated , strings not.

So, maybe this Call Sp operation using some kind of cache mecanism or what can it be? please advice

Kind regards

Sedat,