Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Oracle Scripts
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Please find below the script for the First Audio Video Tutorial in OA Framework

create table xx_person_details
(
 PERSON_ID        NUMBER NOT NULL
,FIRST_NAME       VARCHAR2(50)
,LAST_NAME        VARCHAR2(50)
,EMAIL            VARCHAR2(100)
,student_flag     VARCHAR2(1)
,name_of_university VARCHAR2(100)
,last_update_date DATE
,last_update_login INTEGER
,last_updated_by INTEGER
,creation_date DATE
,created_by INTEGER
) ;


CREATE OR REPLACE PROCEDURE xx_insert_person_prc(p_person_rec IN OUT xx_person_details%ROWTYPE) IS
BEGIN
  SELECT per_people_s.NEXTVAL
  INTO p_person_rec.person_id
  FROM dual;
  p_person_rec.last_update_date  := SYSDATE;
  p_person_rec.creation_date     := SYSDATE;
  p_person_rec.last_update_login := -1;
  p_person_rec.last_updated_by   := 71690;
  p_person_rec.created_by        := 71690;
  INSERT INTO xx_person_details
  VALUES p_person_rec;
END xx_insert_person_prc;
/



DECLARE
  l_person_rec xx_person_details%ROWTYPE;
BEGIN
  l_person_rec.first_name   := 'Anil';
  l_person_rec.last_name    := 'Passi';
  l_person_rec.email        := 'This email address is being protected from spambots. You need JavaScript enabled to view it.';
  l_person_rec.student_flag := 'N';
  xx_insert_person_prc(l_person_rec);
  l_person_rec.first_name := 'Tom';
  l_person_rec.last_name  := 'Kumar';
  l_person_rec.email      := 'This email address is being protected from spambots. You need JavaScript enabled to view it.';
  xx_insert_person_prc(l_person_rec);
  l_person_rec.first_name := 'Mark';
  l_person_rec.last_name  := 'Kapoor';
  l_person_rec.email      := 'This email address is being protected from spambots. You need JavaScript enabled to view it.';
  xx_insert_person_prc(l_person_rec);
  commit;
END;
/

SELECT count(*)
FROM xx_person_details ;


commit;


Anil Passi

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner