摘要: ORA-00911: invalid character
在plsql可正常運行,但C# i程序中就報錯
ORA-00911: invalid character
Cause: Special characters are valid only in certain places. If special characters other than $, _, and # are used in a name and the name is not enclosed in double quotation marks ("), this message will be issued. One exception to this rule is for database names; in this case, double quotes are stripped out and ignored.
Action: Remove the invalid character from the statement or enclose the object name in double quotation marks.
原來只是將組成的SQL語法裡的;分號拿掉,就可以正常運行了~~ ^__^。