annotate docs/source/limitations.rst @ 397:510b6e2f0ae5

bzr works with gerald
author catherine@DellZilla
date Thu, 08 Oct 2009 09:59:12 -0400
parents ba5d5483e0db
children
rev   line source
247
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
1 ===========
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
2 Limitations
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
3 ===========
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
4
287
3ce9a48aa3fc added refresh.bash script for docs
catherine@dellzilla
parents: 247
diff changeset
5 Bug reports and feature requests are welcome at
3ce9a48aa3fc added refresh.bash script for docs
catherine@dellzilla
parents: 247
diff changeset
6 `the project's bug tracker on Assembla <http://trac-hg.assembla.com/sqlpython/report>`_.
3ce9a48aa3fc added refresh.bash script for docs
catherine@dellzilla
parents: 247
diff changeset
7
247
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
8 Slow parsing
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
9 ------------
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
10
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
11 After each line of text in a multi-line command is entered, SQLPython pauses to determine whether
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
12 the command is finished yet. This pause is unnoticable at first, but gradually becomes noticable,
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
13 then annoying, then crippling when very long commands are entered.
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
14
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
15 This problem can be worked around by bracketing long, individual commands in REMARK BEGIN
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
16 and REMARK END statements. When SQLPython finds a REMARK BEGIN, it stops parsing after each
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
17 line and assumes that everything entered until REMARK END is a single statement.
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
18
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
19 PL/SQL
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
20 ------
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
21
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
22 SQLPython interprets short anonymous PL/SQL blocks correctly, as well as one-line PL/SQL
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
23 commands preceded with `exec`. For longer blocks, however, it gets confused about where
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
24 the statement begins and ends.
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
25
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
26 To parse PL/SQL safely, enclose each free-standing PL/SQL block between a REMARK BEGIN and a
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
27 REMARK END statement.
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
28
295
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
29 Unsupported SQL\*Plus commands
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
30 ------------------------------
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
31
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
32 (partial list)
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
33
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
34 * APPEND
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
35
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
36 * ARCHIVE LOG
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
37
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
38 * ATTRIBUTE
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
39
296
ba5d5483e0db shortened docstring to avoid word wrap
catherine@dellzilla
parents: 295
diff changeset
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
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
41
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
42 * COPY (Consider using `cat {table} \\i > table.sql`, `connect -a me@otherplace`, then `@table.sql`)
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
43
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
44 * DEL
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
45
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
46 * DISCONNECT
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
47
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
48 * INPUT
247
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
49
287
3ce9a48aa3fc added refresh.bash script for docs
catherine@dellzilla
parents: 247
diff changeset
50 * PASSWORD
247
f0f293d83337 begin docs
catherine@dellzilla
parents:
diff changeset
51
295
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
52 * RECOVER
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
53
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
54 * SET APPINFO
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
55
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
56 * SET ARRAYSIZE
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
57
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
58 * SET AUTOCOMMIT (but should!)
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
59
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
60 * SET AUTOPRINT (but should!)
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
61
287
3ce9a48aa3fc added refresh.bash script for docs
catherine@dellzilla
parents: 247
diff changeset
62 * SET FEEDBACK OFF
3ce9a48aa3fc added refresh.bash script for docs
catherine@dellzilla
parents: 247
diff changeset
63
295
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
64 * SET AUTOTRACE ON
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
65
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
66 * UNDEFINE
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
67
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
68 * VARIABLE (unneeded; bind variables can be set without pre-defining them)
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
69
ca8db5d7c41d added to docs
catherine@dellzilla
parents: 288
diff changeset
70 * WHENEVER