Hi

I have a database table App, with a primary key,AppID. So I need to insert Data in App, which will auto generate AppID.

My Store Procedure goes something like this:

AppID IN NUMBER
, PersonID IN NUMBER
, ContractorID IN NUMBER
, erfNo IN VARCHAR2
, streetNo IN VARCHAR2

so I need a code to return AppID.

Thanks in advance

I'd use a sequence. As it generates values automatically, no stored procedure is needed at all.

Anyway: if you insist on a stored procedure and returning generated APPID (where to?), you'd have to create an OUT parameter.