mobermaier
Member²
TOrcaleScript seems to have problem with commented semicolons:
CREATE OR REPLACE FORCE VIEW tmp_daily
( resort, resv_name_id, from_resv_id )
AS
-- this is a comment that breaks TOracleScript;
-- only when ; is last non-blank char in line
SELECT
'Resort' , 'Resort1', '1'
FROM DUAL
executed with TOracleQuery works fine, with TOracleScript returns exception 'ORA-00928: missing SELECT keyword'
Anything I'm missing here?
D5 DOA 4.0.6.2
CREATE OR REPLACE FORCE VIEW tmp_daily
( resort, resv_name_id, from_resv_id )
AS
-- this is a comment that breaks TOracleScript;
-- only when ; is last non-blank char in line
SELECT
'Resort' , 'Resort1', '1'
FROM DUAL
executed with TOracleQuery works fine, with TOracleScript returns exception 'ORA-00928: missing SELECT keyword'
Anything I'm missing here?
D5 DOA 4.0.6.2
