Webmaster Forum / Perl / DBI Library / April 2004

I've just discovered that the latest version of Sybase::Simple does
not behave as expected when using the Scalar() routine to get a
stored procedure return status.  It will only work if the stored proc
selects its return status as a result set before it exits.

I'm finding I frequently need to convert the DBI type metadata
from a result set into a string representation (either for display purposes,
or to generate additional queries).
Is there a need/desire to add a new $sth metadata item

Hi Mike,
I have a script that went into an infinite loop after it hit upon certain
Sybase server condition. This is the log snippet.
367606 Server  : MYSERVER

When I execute a repserver command with NSQL in Sybperl's DB-library, where
does the output of commands like "check subscription" go? If you use ISQL
it's not retrieved in a table format like with admin who.
Thanks,

If there's a better list for this question, please point me in the right
direction..!
$ perl -MDBI -le 'print $DBI::VERSION' = 1.42
$ perl -MDBD::Sybase -le 'print $DBD::Sybase::VERSION' = 1.02

I'm trying to convert a very large CGI from dbi::mysql code to dbi::sybase
and am running into some SQL problems (as expected).
How can I easily print out all the sql being sent to the server?
I have used the showerrortext value for errors, but I want to see all the

Any caveats?
Thanks,
Steve

Hi there.  I've been using DBD::PgPP, and I've found (and fixed) some severe
bugs in it.  I've tried to contact Hiroyuki OYAMA, the maintainer of the
module, using the two addresses I've been able to find for him
(hoyama@infoware.ne.jp and oyama@crayfish.co.jp) but I haven't been ...

(I posted this to dbi-users yesterday, but no one's responded, so
here goes.)
I'm using DBD::Sybase 1.02 and DBI 1.42.
The stored procedure writer here is telling me that she's sending

In DBD::Oracle the docs say the script is called explain, but in actuality
it is called ora_explain ...

       sub perform_transaction {
           my ($dbh, $coderef, $allow_non_transaction) = @_;
           my $use_transaction = 1;
           my $orig_AutoCommit = $dbh->{AutoCommit};

Hello Dear Sybperl users,
I got a problem installing Sybperl at the point you have to type: make
At the bottom of the mail I have provided the sybase server, perl,
environment Infos etc.

I just revied the ParamValues docs, and it reminded me of a question I had
WRT ParamValues and prepared statements.
The docs say:
         It is possible that the values in the hash returned by "ParamVal-