diff docs/source/limitations.rst @ 247:f0f293d83337

begin docs
author catherine@dellzilla
date Wed, 04 Mar 2009 17:44:29 -0500
parents
children 3ce9a48aa3fc
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/docs/source/limitations.rst	Wed Mar 04 17:44:29 2009 -0500
@@ -0,0 +1,30 @@
+===========
+Limitations
+===========
+
+Slow parsing
+------------
+
+After each line of text in a multi-line command is entered, SQLPython pauses to determine whether
+the command is finished yet.  This pause is unnoticable at first, but gradually becomes noticable,
+then annoying, then crippling when very long commands are entered.
+
+This problem can be worked around by bracketing long, individual commands in REMARK BEGIN 
+and REMARK END statements.  When SQLPython finds a REMARK BEGIN, it stops parsing after each
+line and assumes that everything entered until REMARK END is a single statement.
+
+PL/SQL
+------
+
+SQLPython interprets short anonymous PL/SQL blocks correctly, as well as one-line PL/SQL
+commands preceded with `exec`.  For longer blocks, however, it gets confused about where
+the statement begins and ends.
+
+To parse PL/SQL safely, enclose each free-standing PL/SQL block between a REMARK BEGIN and a
+REMARK END statement.
+
+Unsupported commands
+--------------------
+
+  * DBMS_OUTPUT.PUT_LINE
+