Using odbc import function of pl/SQL developer tools import excel data, report the following error:

Insert into Scott. Odbc_import (col) values (: name)

ORA - 01036: illegal variable name/number

Do you want to continue?

Excuse me, ladies and gentlemen, this is what went wrong, the developer has localization, excel table column header is just a "name" two characters, not a colon, points after import extra a colon in front of the name?

CodePudding user response:

Check your excel has no special characters, such as annotation what ah

CodePudding user response:

If don't header? Type your column col is number