On Oct 6, 2005, at 2:55 AM, padmanabha konkodi wrote:
i have written function in which while executing it may throw error.
if the error thrown i want rollback the transaction if not i want
commit.
how can i achive this task.
how can catch exception thrown in the function
The function it
i have written function in which while executing it may throw error.
if the error thrown i want rollback the transaction if not i want commit.
BEGIN;
SELECT you_function(args);
...
many sql commands;
...
COMMIT;
that's all
if your function raises an error
whole transaction will be aborted whe
hello sql developers,
i have written function in which while executing it may throw error.
if the error thrown i want rollback the transaction if not i want commit.
how can i achive this task.
how can catch exception thrown in the function
plz help me
regards
konkodi
