Create a Procedure in Oracle (insert)

I want a Procedure in Oracle that will do:

insert A_B with the following values

B_c VARCHAR2(6 BYTE) input,

B_d VARCHAR2(4 BYTE) input

B_e VARCHAR2(20 BYTE) input

B_f NUMBER(18,2), always 99999999999999

B_g NUMBER(18,2) input

B_h NUMBER(18,2) always 99999999999999

B_i NUMBER(4) NOT NULL this year

B_j NUMBER(2) 0


B_l VARCHAR2(40 BYTE) current day time ,

B_m NUMBER(8) 99999999,

B_n NUMBER(16,2) 0,

B_o VARCHAR2(30 BYTE) null,

B_p VARCHAR2(40 BYTE) spaces

It will have an output variable: in the successful insert it will fill with zeros (0)

else the error code

Skills: Oracle, Software Testing

See more: dotnetnuke stored procedure create user, create time counter actionscript, create time simulator vba excel, create time lapse flash script, oracle portal create default template, sql 2005 backup procedure create name, create time calculator visual basic, create time counter flash, create time control windows net, oracle database support time

About the Employer:
( 27 reviews ) Αθήνα, Greece

Project ID: #9376301

Awarded to:


Hi I have 15+ years of experience in app development on oracle database. I have bachelor degree in cs, 22 oracle certified trainings and web app dev certificate from university in Chicago I will be glad to help. P More

$6 USD / hour
(4 Reviews)

2 freelancers are bidding on average $6/hour for this job


Hello, My name is Elena. I am an Oracle developer for 4 years. I can help you with your project. For further questions regarding my experience and my work, do not hesitate to contact me. Best regards, Elena

$5 USD / hour
(2 Reviews)