Hello,
today I came across a PLSQL Developer Command Windows issue.
If you try to run this little script in a Command Window you'll see that the PLSQL Comment "-- /*" code is not correctly interpreted/checked:
BEGIN
-- /* comment
dbms_output.put_line('test');
END;
/
Your SQL*Plus look-a-like Command Window seems to have a interpreter issue because the Command Window is "waiting" for further input, i.e. once you add the comment ending syntax "*/" and the run command "/" the SQL Code interpreting will end but also an error message is then shown because most of the code is evaluated as comments
That piece of code is perfectly executed within in a PLSQL Developer SQL Window or as Package/Program Window -> I assume the SQL code interpreting is done by the Oracle engine instead of PLSQL Developer. SQL*Plus also shows no problems.
I did tests with 8.0 and 7.1.5 - both showed that problem.
Maybe you can take a look at you Command Window Code.
Regards,
J
today I came across a PLSQL Developer Command Windows issue.
If you try to run this little script in a Command Window you'll see that the PLSQL Comment "-- /*" code is not correctly interpreted/checked:
BEGIN
-- /* comment
dbms_output.put_line('test');
END;
/
Your SQL*Plus look-a-like Command Window seems to have a interpreter issue because the Command Window is "waiting" for further input, i.e. once you add the comment ending syntax "*/" and the run command "/" the SQL Code interpreting will end but also an error message is then shown because most of the code is evaluated as comments
That piece of code is perfectly executed within in a PLSQL Developer SQL Window or as Package/Program Window -> I assume the SQL code interpreting is done by the Oracle engine instead of PLSQL Developer. SQL*Plus also shows no problems.
I did tests with 8.0 and 7.1.5 - both showed that problem.
Maybe you can take a look at you Command Window Code.
Regards,
J
Last edited:
