Today i realized that i have some problems with my SP groups. I’m triggering about 7 stored procedures every 10 seconds. This procedures were programed to copy a recipe into the PLC. With the first procedure, I’m copying the header parameters and with the other 6 I copy each ingredient and its parameters (code, weight, status). In order to simplify the procedures, I copy for example, the first 10 ingredients with 1 procedure, another 10 with a second procedure, etc.
The problem is that sometimes, the PLC values aren’t showed correctly so, I changed the type of the TAG (for example, if the PLC value is a Float, I change it to a int and then back to a float) and only then show me the correct value. This is a problem because happens with the weight of the ingredients so sometimes the stored procedure recieve wrong values so another procedure that i use to check the integrity of my recipe says that the recipe have a weight problem being that it’s not true.
I’m using the last JDBC dirver for oracle, ORACLE 10g, RSLINX 2.54, windows XP and IGNITION 7.1.4.
I’m pointing to the tags directly and are not part of my SQLTAGS set.
Thanks in advance.