Is it possible to have one stored procedure reference a result set
generated by another stored procedure that it called?
For example:
sp_2 calls sp_1 to put a result set in a temporary table
sp_2 then does a join with the same temporary table created by sp_1 for a
final result set
I have a com
I'm coding Stored Procedures in MySQL and as a precaution I want to trap
any potential database errors thrown by MySQL. Does MySQL offer specific
system variables that you can interrogate in an if test and take action
accordingly?
Please let me know.
Thanks,
Brandon
--
MySQL General Mailing
What is the MySQL equivalent to Sybase's @@error and @@rowcount? I'm
writing stored procedures where I want to log database error codes.
Please let me know.
Thanks,
Brandon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co