var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stored Procedure
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.