REM-- causes ORA-00900: invalid SQL statement - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer REM-- causes ORA-00900: invalid SQL statement

Print Thread

REM-- causes ORA-00900: invalid SQL statement #21906 03/05/06 09:29 AM
Joined: Feb 2006 Posts: 14 Plano, Texas USA C Clever Idea Consulting OP Member
OP Clever Idea Consulting Member C Joined: Feb 2006 Posts: 14 Plano, Texas USA	Using 7.0.0.1050 Command Window This is not a big problem, but it is inconsitent with SQL*Plus (9iR2 and 10gR2) and I abhor having to fire it up while I'm writing code. In a script, if a line begins with "REM--" immediately prior to any SQL command, that command fails with the ORA-00900. For example: Code REM-- Any text create table xyz ( pdq number ); I ran into this while fiddling around with utPLSQL 2.2 - which has a script that has this syntax. I just bought PL/SQL Developer (and Love it) so that is why I bring this issue up. Thanks, Michael O'Neill Clever Idea Consulting

Re: REM-- causes ORA-00900: invalid SQL statement #21907 03/06/06 11:08 PM
Joined: Aug 1999 Posts: 22,219 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,219	The problem is caused by the REM-- expression. If there is a space between REM and --, it works okay. We'll fix it. Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.081s Queries: 12 (0.036s) Memory: 2.4993 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-15 13:44:44 UTC
Valid HTML 5 and Valid CSS