|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
#1 |
|
Member (11 bit)
Join Date: Apr 2003
Location: Iowa
Posts: 1,652
|
SQL Store Procedure Help ASAP
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.
__________________
LP |
|
|
|
|
|
#2 |
|
Member (11 bit)
Join Date: Apr 2003
Location: Iowa
Posts: 1,652
|
Problem Solved! Spelling errors was all that it was.
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Computer Acronyms | Floppyman | Computer Hardware | 156 | 06-18-2006 06:25 AM |
| my sql | ben862000 | Web Design / Development | 3 | 09-13-2005 10:36 AM |
| Success of Apple Music Store Proves | morriswindgate | General Discussion | 8 | 06-22-2003 01:33 AM |
| SQL Server authentication (asp) | artsapimp | Web Design / Development | 2 | 07-18-2002 06:54 AM |
| XP tip of the day, Nov 5 | reboot | Windows Legacy Support (XP and earlier) | 0 | 11-05-2001 12:32 PM |