Menu

#9 fails to parse cursor in package spec

open
nobody
None
5
2009-10-12
2009-10-12
srr1
No

Parsing file /home/srr/work/onyma/trunk/code/o_res/package/connection.pks ...
Error parsing line 101, column 52
Last consumed token: "is_list"
net.sourceforge.pldoc.parser.ParseException: Encountered "is" at line 101, column 52.
Was expecting one of:
"(" ...
")" ...
"@" ...
"**" ...
"INTERSECT" ...
"MINUS" ...
"UNION" ...
"." ...
"AND" ...
"OR" ...
"||" ...
"+" ...
"-" ...
"*" ...
"/" ...
"=" ...
"<>" ...
"!=" ...
"~=" ...
"^=" ...
"<" ...
">" ...
"<=" ...
">=" ...
"GROUP" ...
"ORDER" ...

at net.sourceforge.pldoc.parser.PLSQLParser.generateParseException(PLSQLParser.java:12010)
at net.sourceforge.pldoc.parser.PLSQLParser.jj_consume_token(PLSQLParser.java:11869)
at net.sourceforge.pldoc.parser.PLSQLParser.select(PLSQLParser.java:6884)
at net.sourceforge.pldoc.parser.PLSQLParser.cursorUnit(PLSQLParser.java:5733)
at net.sourceforge.pldoc.parser.PLSQLParser.cursorSpec(PLSQLParser.java:5744)
at net.sourceforge.pldoc.parser.PLSQLParser.declarativeSection(PLSQLParser.java:1471)
at net.sourceforge.pldoc.parser.PLSQLParser.packageSpec(PLSQLParser.java:551)
at net.sourceforge.pldoc.parser.PLSQLParser.input(PLSQLParser.java:332)
at net.sourceforge.pldoc.PLDoc.processPackage(PLDoc.java:280)
at net.sourceforge.pldoc.PLDoc.run(PLDoc.java:136)
at net.sourceforge.pldoc.PLDoc.main(PLDoc.java:83)
File /home/srr/work/onyma/trunk/code/o_res/package/connection.pks skipped.

--- connection.pks ---
98 cursor calc_resource_props(p_resid number) is
99 select property from prpservices where service=p_resid
100 union
101 select id from props where is_list is null and id in
102 (
103 select property from prpservices where service in
104 (
105 select child_srv from srvdependencies where service=p_resid
106 )
107 );

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.