Difference between sqlplus and sqldeveloper?

Question

I have a sql script file that creates tables and inserts data.

The server runs on Oracle 10g.

When I use sqldeveloper (remote computer) and I run my script everything is perfect. But when I go on the server and I run the same script on the same database, schema, user with sqlplus some error appears (integrity, unique ...) ?

What's the problem, why didn't I have problem on sqldeveloper but did have some on sqlplus? What can cause that?

Answer 1

Ok i found the problems:

• The first was the comment (/* comment */ are not supported or -- comment at the end line)
• I had some anonymous block on my script and I put some / at the begin (by error) and the end. But on sqlplus, the / at the begin, re-execute the previous query.
• After removing the comment i got blank line on some create table and sqlplus have problem with blank line inside the create table.