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