oracle

[shuvo]

I m trying to input data into oracle tables. the problem is that the data's are stored in the form of INSERT Command in Notepads and If I copy those commands into sql plus interface and run then its giving error ...but if i am writing down the code directly then then the same code is working fine...its a huge amound of data i need to input and writing insert code for each one again is impossible...is their any solution...can i run the insert from .sql files or .txt files anyhow?

[Gabriel Fleseriu]

SQL>@C:\path\your_file.sql

will run the file as script in sqlplus. Post a coule of inserts from your textfile, maybe they have a problem.