Go Back   PCMech Forums > Help & Discussion > Web Design / Development

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Old 12-05-2007, 09:37 PM   #1
Member (11 bit)
 
Lespaul20's Avatar
 
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
Lespaul20 is offline   Reply With Quote
Old 12-05-2007, 09:52 PM   #2
Member (11 bit)
 
Lespaul20's Avatar
 
Join Date: Apr 2003
Location: Iowa
Posts: 1,652
Problem Solved! Spelling errors was all that it was.
Lespaul20 is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -5. The time now is 07:33 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2