Dosvak IBM BPM /BAW Products, Download Evaluation
Process & Performance Tools Process & Performance Tools
Code Analyzer Code Analyzer
UI Toolkit UI Toolkit
Integration Monitoring Integration Monitoring
–1 vote
120 views
in Toolkits by (510 points)
Hi,

I have an MS SQL application database. I have a stored procedure with decimal input (18,6).

The stored procedure works correctly when called from   "Microsoft SL Server Management Studies".

When the stored  procedure is called by BPM, the number is rounded to 4 digits. Why?

I use SQL Call Stored Procedure" with this input:

tw.local.sql = " " + "WIDC_SP_AGGIORNACOMP ?

SQL Parameter:

tw.local.parameters[0] = new tw.object.SQLParameter()

tw.local.parameters[0].value = "0.123456";

tw.local.parameters[0].mode = "IN";

tw.local.parameters[0].type = "DECIMAL";

1 Answer

0 votes
by (13.9k points)
can you try with parameters[0].type = VARCHAR

Related questions

+1 vote
1 answer 152 views
0 votes
0 answers 92 views
0 votes
0 answers 30 views
0 votes
1 answer 493 views
0 votes
0 answers 27 views
0 votes
2 answers 485 views
0 votes
1 answer 60 views
0 votes
1 answer 128 views
...