Error when translating execute immediate from Oracle to SQL
O2SS0013, O2SS0356, Oracle error messages, Oracle import/export, Oracle migration, SQL Server import/export, SQL Server Migration Assistant, SSMA, SSMA for Oracle, SSMA warning messages
SSMA warning messages:
* O2SS0356: Conversion from NUMBER datatype can cause data loss.
BEGIN
FETCH emp
INTO @emps$emp_name, @emps$emp_id
IF @@FETCH_STATUS = -1
BREAK
IF @emps$emp_name = 'Avi'
/*
* SSMA error messages:
* O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(...) statement, but dynamic string was not converted. It must be converted manually.
*
EXECUTE (@upd)
*/
DECLARE
@db_null_statement int
END
Software/Hardware used:
Software/Hardware used:
ASKED:
September 9, 2008 7:31 AM
UPDATED:
August 16, 2010 7:57 PM
Answer Wiki:
Do a CAST on the emps$emp_id from an integer to a text string before putting it into the @upd variable.
To see all answers submitted to the Answer Wiki: View Answer History.
how to handle data loss?
when we convert number to float the scale values many get truncated. if the numeric decimal truncation in not a matter then we can ignore the warnings.
Then don’t use float. Use NUMERIC(P,S) instead. If you need 5 numbers to the right of the decimal and 5 to the left use NUMERIC(10,5).