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 .......`(*)'--(*)/---/(*).......