Re: [SQL] on error resume next

2009-07-31 Thread Jasmin Dizdarevic
Hi, that's not really that what i need. I think i will solve it on client side. thank you. jasmin 2009/7/31 Andreas Wenk > Jasmin Dizdarevic wrote: > >> hi, >> can i use savepoints to realize something like "on error resume next"? >> i've got the following situation: >> begin; >> 1. create

Re: [SQL] on error resume next

2009-07-31 Thread Andreas Wenk
Jasmin Dizdarevic wrote: hi, can i use savepoints to realize something like "on error resume next"? i've got the following situation: begin; 1. create view user001.accounts as select * from base.accounts; 2. grant select on user001.accounts to loginuser001; commit; begin; 3. create view

[SQL] on error resume next

2009-07-31 Thread Jasmin Dizdarevic
hi, can i use savepoints to realize something like "on error resume next"? i've got the following situation: begin; 1. create view user001.accounts as select * from base.accounts; 2. grant select on user001.accounts to loginuser001; commit; begin; 3. create view user002.accounts as select * fr