–1 vote
155 views
in Toolkits by (530 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 (16k points)
can you try with parameters[0].type = VARCHAR

Related questions

+1 vote
1 answer 169 views
0 votes
0 answers 101 views
0 votes
0 answers 39 views
0 votes
1 answer 545 views
0 votes
0 answers 33 views
0 votes
2 answers 599 views
0 votes
1 answer 207 views

580 questions

482 answers

85 comments

1.7k users

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
Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
Created by Dosvak LLC
Our Youtube Channel
...