By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,646 Members | 1,175 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,646 IT Pros & Developers. It's quick & easy.

(Slightly OT) - Questions on MySQL 5.0.x stored procs and UDFs

P: n/a
Hi All,

Despite spending the past six to seven hours perusing the docs on the
mySQl site, I still have questions unanswered, and have been unable to
get any help. I am familiar with Sybase, some Oracle and PostgreSQL -
but the mySQL SQL seems a bit "non-standard". I would be very grateful
for any help I get in answering these questions:
Stored procedures
==================
1). can a stored procedure return a data set (i.e. a recordset - one or
more rows )?
2). if yes to question 1, how does one know how many rows were returned?
3). if yes to question 1, how does one access the fields (i.e. columns)
in the returned data ?
4). is it possible to declare an array type as a variable to use within
a stored procedure?
user defined functions (same questions as for stored procedures)
================================================== =====
1). can a UDF return a data set (i.e. a recordset - one or more rows )?
2). if yes to question 1, how does one know how many rows were returned?
3). if yes to question 1, how does one access the fields (i.e. columns)
in the returned data ?
4). is it possible to declare an array type as a variable to use within
a UDF?
tia

Feb 7 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
E.T. Grey wrote:
Hi All,

Despite spending the past six to seven hours perusing the docs on the
mySQl site, I still have questions unanswered, and have been unable to
get any help. I am familiar with Sybase, some Oracle and PostgreSQL -
but the mySQL SQL seems a bit "non-standard". I would be very grateful
for any help I get in answering these questions:
Stored procedures
==================
1). can a stored procedure return a data set (i.e. a recordset - one or
more rows )?
2). if yes to question 1, how does one know how many rows were returned?
3). if yes to question 1, how does one access the fields (i.e. columns)
in the returned data ?
4). is it possible to declare an array type as a variable to use within
a stored procedure?
user defined functions (same questions as for stored procedures)
================================================== =====
1). can a UDF return a data set (i.e. a recordset - one or more rows )?
2). if yes to question 1, how does one know how many rows were returned?
3). if yes to question 1, how does one access the fields (i.e. columns)
in the returned data ?
4). is it possible to declare an array type as a variable to use within
a UDF?
tia


As these are MySQL questions, try asking in comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Feb 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.