The database does not currently support retrieval of procedure text.

[Prashant Nirgun]

Hi
Hi Prashant here i am using following version

PB : Powerbuilder 7 & 9
RDBMS : Mysql 5.1.36 Windows binary 32bit
DOBC : Mysql ODBC Driver 5.1.6
Problem : I had written a stored procedure in mysql which is nothing
but a result set here is syntax
Community : Freeware Software Developement


CREATE PROCEDURE test_rpt (in coid int)
begin
select co_id, it_name from item where co_id = 1;
end


But if i create a datawindow report it wont run and in my databse
painter also i try to run the procedure in isql
windows it gives me an error "The database does not currently support
retrieval of procedure text.;"


What it is? is there any way out to solve this problem.