Very cool sample code and app on MSDN or download the source below.
Run the project, and select the type of LINQ sample that you want to examine. Examine the options, and run each query that interests you. The output from the query and the source code is displayed on the interface of the application.
procedure prc_insert_data(IN_ID in number, ON_PK_VALUE_ID out number) is
insert into MyTable (SEQ_ID)
values (SEQ_ID_PK.nextval) RETURNING PARTNUMBER_ID INTO ON_PK_VALUE_ID;