DB Independent Stored Procedure

[Anon]

Hi,

I am relatively new to DataBases. We have a cross-platform ODBC application which talks to different databases( PostgreSQL, Oracle, MS SQL etc.) I want a simple stored procedures which will return an auto-incremented IDs while executing inserts into the respective tables. PostgreSQL and Oracle has 'Sequence' object, MS SQL has something called 'Identity'

Is there way to do this using simple SQL statements and could be executed as stored procedure. I expect such a procedure useful for multiple different databases.

Thanks,
Narendra