Current Position:Home > Unexpected token on package body

Unexpected token on package body

Update:11-30Source: network consolidation
Advertisement
Tree shows a "Unexpected Token" message and icon for package bodies of some packages. After some investigation we discovered that it happens only when there is a "FOR UPDATE" clause in declared cursors in any of the packages functions. Without the clause the problem disapears. It compiles and runs correctly. Is there a fix for this bug?
Thanks

The Best Answer

Advertisement
Here is a simple test case for the development team:
CREATE OR REPLACE PACKAGE test_token IS
PROCEDURE test_case;
END;
CREATE OR REPLACE PACKAGE BODY test_token IS
PROCEDURE test_case
IS
test_var VARCHAR2(1);
BEGIN
SELECT TRIM('Z')
INTO test_var
FROM dual;
EXCEPTION
WHEN OTHERS THEN NULL;
END test_case;
END;
Using:
SQL Developer 1.0.0.14.67
on Microsoft Windows XP Professional Version 2002 Service Pack2
Oracle 10g Enterprise Edition Release 10.2.0.1
on HP/UX Itanium 11.23
  • Unexpected token on package body Update:11-30

    Tree shows a "Unexpected Token" message and icon for package bodies of some packages. After some investigation we discovered that it happens only when there is a "FOR UPDATE" clause in declared cursors in any of the packages functions.

  • Package body in tree view shows "unexpected token" Update:11-30

    I have a package which is in production for months now. This does not show any error with PL/SQL Developer nor OraEdit. SQL Developer shows "unexpected token" after trying to expand the package into the list of functions and procedures. Database

  • Ati driver install warning unexpected token `}' Update:10-11

    /var/lib/pacman/local/ati-drivers-8.22.5-4/install: line 32: syntax error near unexpected token `}'     do I need to worry about thisit's not fixed at home : [[email protected] nico]# pacman -S ati-drivers                              Targets: ati-driver

  • BUG?: unexpected token in connection pane for cursor declaration Update:11-30

    If I declare a cursor with an order clause in the declaration part of a procedure in a package I will get the unexpected token. The code compiles without errors. SQL Developer 15.57. Windows XP SP2 Oracle 10g example: declare procedure test( param in

  • Mofcomp.exe failed, delete the classes and retry compiling, 0x8004400a unexpected token at file scope, Primary DP will not validate Update:11-30

    I have SCCM 2012 R2 CU3. Before when I've had DP problems it was always with secondary DPs. Now I've got an issue with my primary DP. Content will not validate on the main DP, called DP1. In Monitoring Distribution Point Configuration Status there ar

  • EJB QL "unexpected token: ( " Exception with IN operator and AND operator Update:11-30

    Hey everyone, Hopefully someone can help me. I am just starting to write more complex queries with EJB QL and am running into an issue. When I run my query I get an "Internal Exception: line 1:87: unexpected token: (" Exception below is my query

  • Bug in OC4J [unexpected token: IN] when use Subquery Update:11-30

    Hi I use this named query in my entity, but when I run it from JDeveloper 10.1.3.0.4 (SU2) it throw exception Thia is as sample query: @NamedQuery(name="EmpbyDept",query="SELECT object(o) FROM Employees o WHERE o.departments IN(SELECT objec

  • SQL Developer cloud login - Unexpected token NUMERIC_VALUE encountered Update:11-30

    Dear all I have set up a cloud database, the database is activated. I have reset the published sftp user which was sent by mail and a new user in APEX interface is created, the groups are attached. Now for cloud new connection in SQL Developer -> Use

  • TO_DATE function with JPA, Getting Unexpected Token error Update:11-30

    I am constructing a search query like this from my JAVA code SELECT * FROM EMAIL_PROXY_ERROR_LOG WHERE (to_date((REPLACE (DATETIME,'T',':')),'yyyy-mm-dd:hh24:mi:ss') BETWEEN to_date('2008-04-29:11:30:08','yyyy-mm-dd:hh24:mi:ss') AND to_date('2008-04-

  • Java.sql.SQLException: Unexpected token: IN in statement Update:11-30

    I use Toplink 2.0-b41-beta2 (03/30/2007) and have a problem with the following JPQL query: “SELECT DISTINCT OBJECT(e) FROM Entry e WHERE e.location IN (SELECT loc From View v JOIN v.viewLocs vl JOIN vl.location loc where v.code = :code)” “Entry” is a