stored procedures

[Ivan Smahin]

Hello Danny,

Wednesday, October 3, 2007, 5:47:19 PM, you wrote:

> Thanks for solving that Ivan!
> Is there a way for me, to check where the exception came from? From  
> which instruction, or line in a stored procedure??
> This would come in very handy... I would have maybe found the error  
> myself, but now I didn't know that the exception came from that  
> instruction or line in the stored procedure....
> I know it's a lot to ask for (maybe)....but it would probably save  
> you some time..??

I'm afraid - old-timed tracing tricks only.

Something like this:

...
INSERT INTO t1 VALUES(1);
SET @debugState = 1;

...
SET @debugState = 2;

...

--
call sp1();
SELECT @debugState;


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com