SQL Developer - No readers registered for SQL type error

oracle, oracle-sqldeveloper

Solution

You can call the file directly from sql developer.

Example: If you saved you file to c:\Oracle\MyBackups\Export.sql Then from within Sql Developer, connect to your database and use the sql command:

@C:\Oracle\MyBackups\Export.sql

and that will execute the Export.Sql script.

Problem

I am using Oracle 11g. I had exported data using the installed version of SQL Developer to a sql file called "export.sql". Now, I have downloaded the new version which is 3.1.07 and when I try to import data by clicking on the tree view and choosing Tables | Import Data and navigating to "export.sql", I get the following error: no readers are registered for the sql type When I first started the application it asked for the path to java.exe and I have shown that path and application started. I have the started the application from the path where it was downloaded (C:\users\kaushik\Downloads\sqldeveloper)

Original source