MySQL Forums
Forum List  »  Newbie

Re: Unknown error when runing stored procedure
Posted by: Adrian Sosialuk
Date: January 25, 2008 09:57AM

Hi Ike,

Thanks for your quick reply.

Views - that explains a lot ... Yes - I was thinking about creating a table
and updating it from time to time.

As for your first question I don't know what sort of information I could
provide as it seems to be happening quite randomly. An example could be
as simple as

call find('stock',0);

One more thing - it works perfectly fine with option 1. Option 0 and 2 are
the once causing problems.

I'm considering two reasons for that so far:

1) Memory issue ? Would I really get an unknown error if I run out
of memory ?
2) There is a view in the database created by someone, who doesn't exists
in the database anymore ... Could it be resposible for that ?

Cheers,

Adrian

Options: ReplyQuote


Subject
Written By
Posted
Re: Unknown error when runing stored procedure
January 25, 2008 09:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.