|
|
Posted by Jerry Stuckle on 02/07/06 12:56
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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|