Very Computer

by **Jeroen Ritmeije** » Sat, 01 Dec 2001 02:56:57

Here is one for you that I have difficulties solving. I want to check if the
following statement succeeds

INSERT INTO StoreOrderLine EXEC SMExportOrderLines 55056

For testing purposes I perform a RAISERROR in SMExportOrderLines. If I call

it internally executes the INSERT command last.

Does anyone have a solution for this? Is it possible to return a result code
from SMExportOrderLines and set that to a local variable which I can then
test?

by **Umachandar Jayachandra** » Sat, 01 Dec 2001 14:06:46

Please post some sample code instead of verbal descriptions. How does
your RAISERROR statement look? What is the severity of the error? There are
so many different ways to call RAISERROR. Here is an example that will work
fine:

create proc #s as select 1 raiserror( 'ERROR!', 16, 1 )
go
create table #t( i int )
insert into #t ( i ) exec #s

drop proc #s
drop table #t

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )

by **Jeroen Ritmeije** » Sat, 01 Dec 2001 18:43:56

Your example works, however I am doing the same thing in my code and it
doesn't work there. I was hoping this was a well known problem and therefore
I did not include any code.

Anyway, I created an example to reproduce the problem. Please note that two
different databases are involved.

Database1
-- This procedure has obviously been simplified from it's original version.

BEGIN
raiserror( 'ERROR!', 16, 1 )
END

Database2
CREATE PROCEDURE Test AS
BEGIN

INSERT INTO SMStoreOrderLine

END

> Please post some sample code instead of verbal descriptions. How does
> your RAISERROR statement look? What is the severity of the error? There
are
> so many different ways to call RAISERROR. Here is an example that will
work
> fine:

> create proc #s as select 1 raiserror( 'ERROR!', 16, 1 )
> go
> create table #t( i int )
> insert into #t ( i ) exec #s

> drop proc #s
> drop table #t

> --
> Umachandar Jayachandran
> SQL Resources at http://www.umachandar.com/resources.htm
> ( Please reply only to newsgroup. )

Very Computer

Error handling in T-SQL using compound statements

Error handling in T-SQL using compound statements

Error handling in T-SQL using compound statements

Error handling in T-SQL using compound statements