Re: Stored Proc. What's missing

Are you using isql? I have run into problems before using isql to create SPs. When I use dbaccess it works just fine. I have no idea why isql does not work when dbaccess does. Anyone? BTW, I used dbacccess to create this SP and it works. I used isql and got the same error you did. Don. Robert Ogren wrote: > Question: > This is more than likely a simple one but I am not seeing what would be > causing this not to work. > > create procedure er_raise_error(laerrId int, laerrMsg char(255)) > raise exception laerrId,0,laerrMsg;> 201: A Syntax error occurred ^> end procedure; > > In a trigger I call the above Procedure. > Example: > execute procedure er_raise_error(-20012,'tblInvDelTrig: Cannot delete > because foreign keys still exist in tblRacktblInv ')> > I have permission to create procedures in the DB. > > Any help is appreciated. > > Thanks > > Rob > rmogren@gte.net