Multiset Conditions are not recognized
Status: Alpha
Brought to you by:
altumano
Menu
▾
▴
#82 Multiset Conditions are not recognized
Multiset Conditions (e.g. MEMBER OF) are not know by the parser:
net.sourceforge.pldoc.parser.ParseException: Encountered "MEMBER" at line 21, column 47.
Was expecting one of:
"/" ...
"=" ...
"!" ...
"<" ...
">" ...
"+" ...
"-" ...
"||" ...
"**" ...
"*" ...
"AND" ...
"BETWEEN" ...
"FROM" ...
"IN" ...
"IS" ...
"LIKE" ...
"MOD" ...
"NOT" ...
"OR" ...
"THEN" ...
"." ...
"(" ...
":" ...
at net.sourceforge.pldoc.parser.PLSQLParser.generateParseException(PLSQLParser.java:31615)
at net.sourceforge.pldoc.parser.PLSQLParser.jj_consume_token(PLSQLParser.java:31462)
at net.sourceforge.pldoc.parser.PLSQLParser.statement(PLSQLParser.java:8374)
at net.sourceforge.pldoc.parser.PLSQLParser.statement(PLSQLParser.java:8994)
at net.sourceforge.pldoc.parser.PLSQLParser.statement(PLSQLParser.java:8377)
at net.sourceforge.pldoc.parser.PLSQLParser.programUnit(PLSQLParser.java:5770)
at net.sourceforge.pldoc.parser.PLSQLParser.declarativeUnit(PLSQLParser.java:2166)
at net.sourceforge.pldoc.parser.PLSQLParser.declarativeSection(PLSQLParser.java:2534)
at net.sourceforge.pldoc.parser.PLSQLParser.packageBody(PLSQLParser.java:1612)
at net.sourceforge.pldoc.parser.PLSQLParser.input(PLSQLParser.java:630)
at net.sourceforge.pldoc.PLDoc.processPackage(PLDoc.java:489)
at net.sourceforge.pldoc.PLDoc.run(PLDoc.java:190)
at net.sourceforge.pldoc.PLDoc.main(PLDoc.java:124)
Package d:\Temp\Pmd_parameter.sql skipped.
Example statement:
SELECT customer_id, cust_address_ntab
FROM customers_demo
WHERE cust_address_typ('8768 N State Rd 37', 47404,
'Bloomington', 'IN', 'US')
MEMBER OF cust_address_ntab
ORDER BY customer_id;
see Oracle doc for details: http://docs.oracle.com/cd/B28359_01/server.111/b28286/conditions006.htm
PL/SQL Package with Multiset Condition
Proposal for solution