receiver jdbc adapter:how to implement the insert or update action in a sql

Hi,gurus:

I'm using receiver jdbc adapter now.

You know, we have to gave the action the value 'update' or 'insert',but in our case,the action is variant--update or insert.It decides whether the record exists in the outer database.

Can stored procedure do this?If I use stored procedure,then must I create a stored procedure in the outer database?

Or some other ways to solute my issue?

THanks in advance.