Using paypal pro offers 2 payment methods:
1) The user stays on your site and enters CC details
2) Paypal Express - if they select this option, they go to the paypal site to set the payment method, and are brought back to your site to complete the transaction.
in both cases, the order is only saved to the DB if the transaction is successful.