Devart Forums

Code: Select all

CREATE OR REPLACE VIEW test_schema.view1 AS 
WITH
  FUNCTION func1 RETURN VARCHAR2 IS 
  BEGIN
    RETURN 'test';
  END;
(
  SELECT col1, func1 FROM test_schema.table1;
);
/

Code: Select all

ORA-06553: PLS-103: Encountered the symbol "end-of-file" when expecting one of the following:

   * & = - + ; < / > at in is mod remainder not rem
   <an exponent (**)> <> or != or ~= >= <= <> and or like like2
   like4 likec between || multiset member submultiset

Code: Select all

      script.ScriptText = @" 
CREATE OR REPLACE VIEW view1 AS 
WITH
  FUNCTION func1 RETURN VARCHAR2 IS 
  BEGIN
    RETURN 'test';
  END;
  SELECT dname, func1 FROM dept
/
";

Code: Select all

      script.ScriptText = @" 
CREATE OR REPLACE VIEW view1 AS 
WITH
  FUNCTION func1 RETURN VARCHAR2 IS 
  BEGIN
    RETURN 'test';
  END;
(
  SELECT dname, func1 FROM dept
)
/
";