Get Return Value after inserted

[Jo Seph]

Hi,

Recently i start to play with MySQL but i facing a problem which is

when using normal Stored procedures without 'Transaction' for inserting, after inserted it will return value 1 or more (show successfully inserted)

but when i using transaction for inserting the problem occur,
Success nor failed , the return value will still is 0

Is this normal for the return value with 0 when using transaction in procedure?
if so, how to determine whether it success or fail?

Thank You