Yes, I agree that syntax could be different for some or the other application but this should not be the case when you are doing it through the script. like as in the example you said in SQL Developer you need to wrap, this is the way sql developer tells server to execute the statement.
anyways are you able to execute the same statement on either of the the application ie SQL plus or sql dev
bcoz what i found about ORA-00900: invalid SQL statement is
"The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed. "
which i beleive is a syntax error and correcting that should solve the issue.
let me know your comments on this.
anyways are you able to execute the same statement on either of the the application ie SQL plus or sql dev
bcoz what i found about ORA-00900: invalid SQL statement is
"The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed. "
which i beleive is a syntax error and correcting that should solve the issue.
let me know your comments on this.
