#7 Compile Local File does not recognise some syntax

[Anonymous]

Originally created by: jimnicho...@gmail.com

What steps will reproduce the problem?
1. Select package with offending syntax
2. Use Right click on the package to compile local file
3. View compile errors

What is the expected output? What do you see instead?
The "Forward Declaration" of a procedure raised a compile error "Missmatched input ";" expecting set null.
Also
Rollback to <savepointname>
gave a syntax error with the verb "TO"

What version of the product are you using? On what operating system?
Version 2.1 on Netbeans 6.9 using Oracle 11gR1 database (11.1.0.4)

Please provide any additional information below.

[Anonymous]

Originally posted by: alexan...@sumsoftsolutions.com

Whould you please provide the code sample?

[Anonymous]

Originally posted by: jimnicho...@gmail.com

Here is a code snippet that shows the syntax failures.

create or replace package JimsTest is

  -- Author  : Jim
  -- Created : 9/02/2011 08:56:39
  -- Purpose : Testing out stuff
 
  function MyFunction(iString IN VARCHAR2) return VARCHAR2;

end JimsTest;
/
create or replace package body JimsTest is

  FUNCTION MyIntFunction(iString IN VARCHAR2) return VARCHAR2;
  FUNCTION MyIntFunction(iString IN VARCHAR2) return VARCHAR2 is
    l_String    VARCHAR2(250) := iString;
   
  BEGIN
    SAVEPOINT MyPoint;
    FOR i IN 1..10 LOOP
        dbms_lock.sleep(seconds => 1);
    END LOOP;
    ROLLBACK TO MyPoint;
    RETURN l_String;
  end;
  FUNCTION MyFunction(iString IN VARCHAR2) return VARCHAR2 IS
  BEGIN
    RETURN MyIntFunction(iString => iString);
  END;
begin
  -- Initialization
    NULL;
end JimsTest;
/

[Anonymous]

Originally posted by: alexan...@sumsoftsolutions.com

(No comment was entered for this change.)

Status: Accepted

[Anonymous]

Originally posted by: alexan...@sumsoftsolutions.com

Fixed in [r170].

Status: Fixed