At 03:28 PM 11-10-02 -0700, you wrote:

>Martijn,
>
>what do you mean by calling application?
>i have to commit the procedure if it is succeed. if not, i need to rollback.
>why can't i control this inside the procedure? why should be done by the
>calling application?

Because a transaction is a conversation between the client and the
server. This gets down to the *purpose* of transactions, which is to
isolate the work of one client task from all others'. Although there are a
few (hidden) situations where the server runs transactions itself,
server-side transactions in user code are not supported.

heLen