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

[E.T. Grey]

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

[Jerry Stuckle]

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

E.T. Grey wrote:[color=blue]
> 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
>[/color]

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

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===