RE: MYSQL Stored Procedur Error

[Pravesh Patel]

Hi,

I get the following error:
Procedure or function '`sp_name`' cannot be found in database '`database`'

I wrote function the builds a stored procedure, passing the store procedure parameters. The function inturn is used in a dataset function, which uses a data adapter to autofill the dataset before function returns the dataset.

I know th stored procedure work because when I run it manually with specified parameter values it returns records from a table that it builds.

The stored procedure is programmed to drop and re-create the table on the fly, every time it is executed, to avoid duplicate records. I was wondering if anyone has a solution. Maybe the the stored procedure function is dropping and re-creating the able sychronously, therefore when the dataadapter is trying to fill the dataset, it is doing so when the table has not been created as yet.

I hope someone out there has a resolution to this problem.