|
247
|
1 ===========
|
|
|
2 Limitations
|
|
|
3 ===========
|
|
|
4
|
|
287
|
5 Bug reports and feature requests are welcome at
|
|
|
6 `the project's bug tracker on Assembla <http://trac-hg.assembla.com/sqlpython/report>`_.
|
|
|
7
|
|
247
|
8 Slow parsing
|
|
|
9 ------------
|
|
|
10
|
|
|
11 After each line of text in a multi-line command is entered, SQLPython pauses to determine whether
|
|
|
12 the command is finished yet. This pause is unnoticable at first, but gradually becomes noticable,
|
|
|
13 then annoying, then crippling when very long commands are entered.
|
|
|
14
|
|
|
15 This problem can be worked around by bracketing long, individual commands in REMARK BEGIN
|
|
|
16 and REMARK END statements. When SQLPython finds a REMARK BEGIN, it stops parsing after each
|
|
|
17 line and assumes that everything entered until REMARK END is a single statement.
|
|
|
18
|
|
|
19 PL/SQL
|
|
|
20 ------
|
|
|
21
|
|
|
22 SQLPython interprets short anonymous PL/SQL blocks correctly, as well as one-line PL/SQL
|
|
|
23 commands preceded with `exec`. For longer blocks, however, it gets confused about where
|
|
|
24 the statement begins and ends.
|
|
|
25
|
|
|
26 To parse PL/SQL safely, enclose each free-standing PL/SQL block between a REMARK BEGIN and a
|
|
|
27 REMARK END statement.
|
|
|
28
|
|
|
29 Unsupported commands
|
|
|
30 --------------------
|
|
|
31
|
|
287
|
32 * PASSWORD
|
|
247
|
33
|
|
287
|
34 * SET FEEDBACK OFF
|
|
|
35
|
