I find a script that I have copied and saved on the notepad as all files with extension .sql. (REPORT.sql)
when running the script on the sqlplus, i was getting the following error.
SP2-0310: Unable to open file "report.sql"
Can someone tell me what that error is about? and how to go by correcting it?
You might check for a 'report.sql.txt'. I have had that happen a couple of times.
Make sure you have save ur file in ORACLE_HOME/bin directory becuase by default it looks into this directory for the file you might have saved it in a differnt directory
Search for the location of the file. It may be in the Oracle Bin directory.
c:> sta (full path)\report.sql
or else copy the file to the c:>
C:> sta report.sql (or @report.sql)
If you do not specify a path while saving it gets saved to the Oracle bin directory by default.