#1520 [plsql] Missing PL/SQL language constructs in parser: Is Of Type, Using

PMD-5.3.8
closed
None
PMD
3-Major
Bug
2016-11-04
2016-09-05
No

There are PL/SQL language constructs missing in parser, which cause the code scan to fail.

  1. Missing "is of" object comparison operator.

The language syntax is described here:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions014.htm

this causes the following code snippet to fail:

...
member PROCEDURE InsClientTrans (
inChannelID IN number,
inOperID IN number,
inClientId IN number,
ioFPOobj IN FPO_OBJ,
inPackageIDout IN number,
inStatusId IN number)
is
loFPOGE_OBJ FPOGE_OBJ;
BEGIN
IF ioFPOobj IS OF (FPOGE_OBJ) THEN
loFPOGE_OBJ:=treat(ioFPOobj AS FPOGE_OBJ);
end if;
end;
...

  1. Missing "using" support for the OPEN-FOR-USING statement

The language syntax is described here:

https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/13_elems034.htm

The problematic part is the using clause and the in specifiaction for bind parameter:

open cursor for query USING IN variable

Discussion

  • Andreas Dangel

    Andreas Dangel - 2016-11-04
    • summary: Missing PL/SQL language constructs in parser --> [plsql] Missing PL/SQL language constructs in parser: Is Of Type, Using
    • status: open --> in-progress
    • assigned_to: Andreas Dangel
    • Milestone: New Tickets --> PMD-5.3.8
     
  • Andreas Dangel

    Andreas Dangel - 2016-11-04
    • status: in-progress --> closed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks