> what do you mean by calling application?

The calling application is the client application that executes the
procedure.

> why can't i control this inside the procedure?

Because it cannot be done.

> i have to commit the procedure if it is succeed. if not, i need to

rollback.

Do what Helen suggested - either catch the exception and raise another
one and let the calling applicaton rollback or commit, depending on the
output.

>why should be done by the calling application?

Because this is the only way.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."