Database Administration (MOSC)

MOSC Banner

sqlplus and Sqldevloper ORA-00911

edited Sep 23, 2022 2:06PM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi,

On 11.2.0.4 on AIX

I have a file with  thousands of lines like this:

update table set col1='XXX'; commit;

When I run it in sqlplus , I receive:

ERROR at line 1:

ORA-00911: invalid character

But when I paste the content of file in sqldevloper it works fine and I have:

line updated

commit complete.

Do you have any explantion please?

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center