Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cursor for loop #6

Open
PeteCreme opened this issue Jun 4, 2019 · 0 comments
Open

Cursor for loop #6

PeteCreme opened this issue Jun 4, 2019 · 0 comments

Comments

@PeteCreme
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant