Oracle Database & ASP.NET Sample (Code Utilising Oracle Ref Cursor or Collection)

I need some SAMPLE CODE created with an Oracle database & .Net Interface. to demonstrate how to copy data to 2 separate tables (one to many ) with a single stored procedure.

---------------------------------------------------------------------------

Oracle Relationships Database with 2 tables

---------------------------------------------------------------------------

Table 1: Applications

---------------------------------------------------------------------------

Fields:

ApplicationID | Auto Generate ID

ApplicationType | String

---------------------------------------------------------------------------

Table 2: Applicants

---------------------------------------------------------------------------

Fields:

ApplicantID | Auto Generate ID

ApplicationID | passed from Table 1 (Applications) as a key

FirstName | String

LastName | String

Age | int

Comment | String

---------------------------------------------------------------------------

.Oracle DB Stored Procedure

---------------------------------------------------------------------------

Create a single stored procedure that can except from .Net in a SINGLE Transaction the application and the applicants' details. For each application there is multiple applicants . Stored procedure must make use of either Oracle “ref cursor” or “collections” to store multiple applicants against a single application in one .net call

---------------------------------------------------------------------------

.NET CODE

---------------------------------------------------------------------------

Generate the required code to pass to the stored procedure the required values

In your code use the 2 below data sample sets;

Data Set 01:

ApplicationType = “Coal”

Applicant1| FirstName: Mark, LastName: Smith, Age:55, Comment: I wasn’t sure

Applicant2| FirstName: James, LastName: Gate, Age:34, Comment: I want the "right" size land

Data Set 02 :

ApplicationType = “Petrol”

Applicant1| FirstName: Bill, LastName: Smith, Age:44, Comment: the first on the seen

Applicant2| FirstName: Oliver, LastName: webbing, Age:61, Comment: explore 1'st choice

Applicant3| FirstName: Bob, LastName: wong, Age:30, Comment: NULL or Empty String

.Net Code

ASP.NET Oracle

Numer ID Projektu: #12990348

O projekcie