|
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
|
|
295
|
29 Unsupported SQL\*Plus commands
|
|
|
30 ------------------------------
|
|
|
31
|
|
|
32 (partial list)
|
|
|
33
|
|
|
34 * APPEND
|
|
|
35
|
|
|
36 * ARCHIVE LOG
|
|
|
37
|
|
|
38 * ATTRIBUTE
|
|
|
39
|
|
296
|
40 * BREAK, BTITLE, CLEAR, COLUMN, COMPUTE, REPFOOTER, REPHEADER, and all SQL\*Plus report formatting commands. In my opinion, special sqlpython output is much more powerful than SQL\*Plus report-formatting anyway.
|
|
295
|
41
|
|
|
42 * COPY (Consider using `cat {table} \\i > table.sql`, `connect -a me@otherplace`, then `@table.sql`)
|
|
|
43
|
|
|
44 * DEL
|
|
|
45
|
|
|
46 * DISCONNECT
|
|
|
47
|
|
|
48 * INPUT
|
|
247
|
49
|
|
287
|
50 * PASSWORD
|
|
247
|
51
|
|
295
|
52 * RECOVER
|
|
|
53
|
|
|
54 * SET APPINFO
|
|
|
55
|
|
|
56 * SET ARRAYSIZE
|
|
|
57
|
|
|
58 * SET AUTOCOMMIT (but should!)
|
|
|
59
|
|
|
60 * SET AUTOPRINT (but should!)
|
|
|
61
|
|
287
|
62 * SET FEEDBACK OFF
|
|
|
63
|
|
295
|
64 * SET AUTOTRACE ON
|
|
|
65
|
|
|
66 * UNDEFINE
|
|
|
67
|
|
|
68 * VARIABLE (unneeded; bind variables can be set without pre-defining them)
|
|
|
69
|
|
|
70 * WHENEVER
|
