Error when translating execute immediate from Oracle to SQL

5 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

Do a CAST on the emps$emp_id from an integer to a text string before putting it into the @upd variable.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ayyappan
    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.
    10 pointsBadges:
    report
  • Denny Cherry
    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).
    66,070 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following