You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm getting errors migrating a simple cursor for loop.
The setup is python 3.6 on rhel 7.6 with a virtual environment (venv), so that I could load the modules.
The source is:
DECLARE
cursor c1 is
select name
from employees
order by name;
BEGIN
for r1 in c1 loop
dbms_output.put_line(r1.name);
end loop;
END;
/
The output is:
(priscilla) [:/opt/git/priscilla ]$ make migrate
python3 lib/S2S.py /opt/git/priscilla/input/ccr.pkg /opt/git/priscilla/output/ccr.py
Traceback (most recent call last):
File "lib/S2S.py", line 37, in
main(sys.argv)
File "lib/S2S.py", line 23, in main
node = tree.accept(visitor)
File "./built/PlSqlParser.py", line 7324, in accept
return visitor.visitSql_script(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 43, in visitSql_script
body = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 7541, in accept
return visitor.visitUnit_statement(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 52, in visitUnit_statement
ret = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 32606, in accept
return visitor.visitAnonymous_block(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 59, in visitAnonymous_block
return self.visitBody(ctx)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 220, in visitBody
ret = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 34570, in accept
return visitor.visitSeq_of_statements(self)
File "./built/PlSqlParserVisitor.py", line 1394, in visitSeq_of_statements
return self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 34757, in accept
return visitor.visitStatement(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 286, in visitStatement
ret = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 35423, in accept
return visitor.visitLoop_statement(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 292, in visitLoop_statement
ret = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 35534, in accept
return visitor.visitCursor_loop_param(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 310, in visitCursor_loop_param
target = ctx.index_name().getText().upper()
AttributeError: 'NoneType' object has no attribute 'getText'
make: *** [/opt/git/priscilla/output/ccr.py] Error 1
Any help appreciated thanks.
The text was updated successfully, but these errors were encountered:
I'm getting errors migrating a simple cursor for loop.
The setup is python 3.6 on rhel 7.6 with a virtual environment (venv), so that I could load the modules.
The source is:
DECLARE
cursor c1 is
select name
from employees
order by name;
BEGIN
for r1 in c1 loop
dbms_output.put_line(r1.name);
end loop;
END;
/
The output is:
(priscilla) [:/opt/git/priscilla ]$ make migrate
python3 lib/S2S.py /opt/git/priscilla/input/ccr.pkg /opt/git/priscilla/output/ccr.py
Traceback (most recent call last):
File "lib/S2S.py", line 37, in
main(sys.argv)
File "lib/S2S.py", line 23, in main
node = tree.accept(visitor)
File "./built/PlSqlParser.py", line 7324, in accept
return visitor.visitSql_script(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 43, in visitSql_script
body = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 7541, in accept
return visitor.visitUnit_statement(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 52, in visitUnit_statement
ret = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 32606, in accept
return visitor.visitAnonymous_block(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 59, in visitAnonymous_block
return self.visitBody(ctx)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 220, in visitBody
ret = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 34570, in accept
return visitor.visitSeq_of_statements(self)
File "./built/PlSqlParserVisitor.py", line 1394, in visitSeq_of_statements
return self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 34757, in accept
return visitor.visitStatement(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 286, in visitStatement
ret = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 35423, in accept
return visitor.visitLoop_statement(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 292, in visitLoop_statement
ret = self.visitChildren(ctx)
File "/opt/python_venv/priscilla/lib64/python3.6/site-packages/antlr4/tree/Tree.py", line 44, in visitChildren
childResult = c.accept(self)
File "./built/PlSqlParser.py", line 35534, in accept
return visitor.visitCursor_loop_param(self)
File "/opt/git/priscilla/lib/ScriptVisitor.py", line 310, in visitCursor_loop_param
target = ctx.index_name().getText().upper()
AttributeError: 'NoneType' object has no attribute 'getText'
make: *** [/opt/git/priscilla/output/ccr.py] Error 1
Any help appreciated thanks.
The text was updated successfully, but these errors were encountered: