Hello,

Is there a limit on the size of a statement that you can 'prepare' or 
'do' in DBI?  I am trying to create a stored procedure on Sybase using 
DBI and DBD::Sybase.  It looks a little bit like this:

$rv = $dbh->do(<<EOF
create procedure sp_myhelp
\@objname varchar(92) = NULL
with recomile as
...
EOF
);

This works fine with small stored procedures, but I have one large one
that I need to create.  It is basically a modified version of sp_help
and is almost 300 lines long.  

These are the errors from $dbh->errstr when the prepare or do fails:

Server message number=111 severity=15 state=1 line=1 procedure=DBD41c6
text=PREPARE must be the first command in a query batch.
Server message number=137 severity=15 state=2 line=19 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=60 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=75 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=83 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=145 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=171 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=181 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=214 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=224 procedure=DBD41c6
text=Must declare variable '@objname'.
Server message number=137 severity=15 state=2 line=260 procedure=DBD41c6
text=Must declare variable '@objname'.

Tami

-- 
                                                <|
 Tami King                                       |___      __o __o
 [EMAIL PROTECTED]                                     |   \   _`\<,`\<,
 http://www.cis.ohio-state.edu/~tami      .......`(*)'--(*)/---/(*).......
 

Reply via email to