FreeTDS Development Group

[Guangbin Liu <GLiu AT interland.com>]

I read the DBD::Sybase docs, but I still can't make it work.

There is a stored procedures in MS SQL Server, sp_help, and I call it using
following code:
$sth = $dbh->prepare("exec sp_help");
$sth->execute;
@results = $sth->func('syb_output_params');
$type = $sth->{syb_result_type};
print "result type is $type \n";
print "results are: @results \n";

What I got is:
result type is 14
results are:

According to the DBD::Sybase docs, the result type should be 4043
CS_STATUS_RESULT, and the results 
should not be empty. What's wrong with my code?

Another question, how can I pass parameter into stored procedures?

Could somebody give me a sample code to call stored procedures and process
the output?

Thanks in advance!

Guangbin
-----Original Message-----
From: Michael Peppler [mailto:mpeppler AT peppler.org]
Sent: Tuesday, May 30, 2000 1:44 PM
To: TDS Development Group
Subject: [freetds] Re: Use Stored procedures in
DBD::Sybase/FreeTDS/MS-SQL7.0


Guangbin Liu wrote:

> I'm using FreeTDS/DBD::Sybase/Ms-SQL7.0 and I want to call stored
> procedures in my program. How can I do it? From DBI document, "calling
> stored procedures is currently not defined by the DBI".

Please read the DBD::Sybase docs.

Michael



---
You are currently subscribed to freetds as: GLiu AT interland.com
To unsubscribe, forward this message to
$subst('Email.Unsub')