Lespaul20
12-05-2007, 10:37 PM
I'm working on a project and I'm stuck on a stored procedure for Oracle SQL.
CREATE OR REPLACE PROCEDURE ADD_RES_SP
(
RESERVATION_ID in RESERVATION.RESERVATION_ID%TYPE,
DATE_CREATED IN RESERVATION.DATE_CREATED%TYPE,
START_DATE IN RESERVATION.START_DATE%TYPE,
END_DATE IN RESERVATION.END_DATE%TYPE,
EMP_ID IN RESERVATION.EMP_ID%TYPE,
NUM_OF_PEOPLE IN RESERVATION.NUM_OF_PEOPLE%TYPE,
ACCOUNT_ID IN RESERVATION.ACCOUNT_ID%TYPE,
CUST_ID IN RESERVATION.CUST_ID%TYPE,
RES_STATUS IN RESERVATION.RES_STATUS%TYPE,
WALK_IN IN RESERVATION.WALK_IN%TYPE,
CHECK_OUT_TIME IN CHECK_OUT_TIME%TYPE,
ROOM_ID IN CORRESPONDS.ROOM_ID%TYPE,
CREDIT_CARD_NUM IN CREDIT_CARD.CREDIT_CARD_NUM%TYPE,
CC_EXPIRE_DATE IN CREDIT_CARD.CC_EXPIRE_DATE%TYPE,
REQUEST_ID IN REQUESTED.REQUEST_ID%TYPE,
DISCOUNT_ID IN DISCOUNT.DISCOUNT_ID%TYPE,
TAX_RATE IN INVOICE.TAX_RATE%TYPE,
INVOICE_ID IN INVOICE.INVOICE_ID%TYPE)
AS
BEGIN
INSERT INTO RESERVATION VALUES(RESERVATION_ID,DATE_CREATED,START_DATE,END_DATE,EMP_ID,NUM_OF_PEOPLE,ACCOUNT_ID,CUST_ID,RES_S TATUS,WALK_IN,CHECK_OUT_TIME);
INSERT INTO REQUESTED VALUES(REQUEST_ID,RESERVATION_ID);
INSERT INTO DISCOUNT VALUES(RESERVATION_ID,DISCOUNT_ID);
INSERT INTO CREDIT_CARD VALUES(CREDIT_CARD_NUM,RESERVATION_ID,CC_EXPIRE_DATE);
INSERT INTO CORRESPONDS VALUES(RESERVATION_ID,ROOM_ID);
INSERT INTO INVOICE VALUES(INVOICE_ID,RESERVATION_ID,TAX_RATE);
END;
/
This is what error I get, I'm using ORACLE Application Express.
Error at line 0: PL/SQL: Compilation unit analysis terminated
Any Ideas?
This is due tomorrow so any help is needed tonight.
Thanks.
CREATE OR REPLACE PROCEDURE ADD_RES_SP
(
RESERVATION_ID in RESERVATION.RESERVATION_ID%TYPE,
DATE_CREATED IN RESERVATION.DATE_CREATED%TYPE,
START_DATE IN RESERVATION.START_DATE%TYPE,
END_DATE IN RESERVATION.END_DATE%TYPE,
EMP_ID IN RESERVATION.EMP_ID%TYPE,
NUM_OF_PEOPLE IN RESERVATION.NUM_OF_PEOPLE%TYPE,
ACCOUNT_ID IN RESERVATION.ACCOUNT_ID%TYPE,
CUST_ID IN RESERVATION.CUST_ID%TYPE,
RES_STATUS IN RESERVATION.RES_STATUS%TYPE,
WALK_IN IN RESERVATION.WALK_IN%TYPE,
CHECK_OUT_TIME IN CHECK_OUT_TIME%TYPE,
ROOM_ID IN CORRESPONDS.ROOM_ID%TYPE,
CREDIT_CARD_NUM IN CREDIT_CARD.CREDIT_CARD_NUM%TYPE,
CC_EXPIRE_DATE IN CREDIT_CARD.CC_EXPIRE_DATE%TYPE,
REQUEST_ID IN REQUESTED.REQUEST_ID%TYPE,
DISCOUNT_ID IN DISCOUNT.DISCOUNT_ID%TYPE,
TAX_RATE IN INVOICE.TAX_RATE%TYPE,
INVOICE_ID IN INVOICE.INVOICE_ID%TYPE)
AS
BEGIN
INSERT INTO RESERVATION VALUES(RESERVATION_ID,DATE_CREATED,START_DATE,END_DATE,EMP_ID,NUM_OF_PEOPLE,ACCOUNT_ID,CUST_ID,RES_S TATUS,WALK_IN,CHECK_OUT_TIME);
INSERT INTO REQUESTED VALUES(REQUEST_ID,RESERVATION_ID);
INSERT INTO DISCOUNT VALUES(RESERVATION_ID,DISCOUNT_ID);
INSERT INTO CREDIT_CARD VALUES(CREDIT_CARD_NUM,RESERVATION_ID,CC_EXPIRE_DATE);
INSERT INTO CORRESPONDS VALUES(RESERVATION_ID,ROOM_ID);
INSERT INTO INVOICE VALUES(INVOICE_ID,RESERVATION_ID,TAX_RATE);
END;
/
This is what error I get, I'm using ORACLE Application Express.
Error at line 0: PL/SQL: Compilation unit analysis terminated
Any Ideas?
This is due tomorrow so any help is needed tonight.
Thanks.