| Data getting truncated while passing a data of type Number(3,2) from SHELL script to ORACLE Proc [message #453306] |
Wed, 28 April 2010 03:55  |
gokul_ifs
Messages: 41
Registered: March 2006
Location: india
|
Member |
|
|
I am passing a number of datatype Number(3,2) from shell script to a PL/SQL stored proc.
From shell script I am passing 101.10 as the second argument($2).
For eg:
targetDB=$1
rollnumber=$2
echo "exec registerroll('$targetDB', $rollnumber);" >> ${REGISTER_ROLL_FILENAME}
But, in the stored proc the value is truncated as 101.1
Lets say the stored proc "registerroll" is inserting rollnumber into role table.
The rollnumber gets inserted as 101.1
but the actual data I am passing is 101.10
Suggestions to fix this ll be highly appreciated.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
