Hi, Thanks for your prompt reply. I think I didn't explained the problem clearly. Actually when a client (from an application like java) tries to access the server database which is in network How could I solve the problem. Is 'RAISE EXCEPTION' solves the above problem. If so please explain me.
regards, Deepa K. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend