Please, Help to find a mistake in SQL!

Question

Guys, I can't run it because it gives me a syntax error. I can't see it. Please, help ASAP!
P.S.: Good Validator for SQL?

1)
CREATE OR REPLACE PROCEDURE PROC_GUIDE_NAME (
I_GUIDE_NUM IN GUIDE.GUIDE_NUM%TYPE,
I_FIRST_NAME OUT GUIDE.FIRST_NAME%TYPE)
AS
BEGIN
SELECT FIRST_NAME, LAST_NAME
INTO
I_FIRST_NAME, I_LAST_NAME
FROM
GUIDE
WHERE
GUIDE_NUM = I_GUIDE_NUM;
DBMS_OUTPUT.PUT_LINE(I_FIRST_NAME || ‘’ || I_LAST_NAME);
END;

2)
CREATE OR REPLACE PROCEDURE PROC_RESV(
I_CUSTOMER_NUM IN RESERVATION.CUSTOMER_NUM%TYPE,
I_RESERVATION_ID OUT RESERVATION.RESERVATION_ID%TYPE,
I_TRIP_ID OUT RESERVATION.TRIP_ID%TYPE,
I_NUM_PERSONS OUT RESERVATION.NUM_PERSONS%TYPE,
I_TRIP_PRICE OUT RESERVATION.TRIP_PRICE%TYPE)
AS
BEGIN
SELECT RESERVATION_ID, TRIP_ID, NUM_PERSONS, TRIP_PRICE
INTO
I_RESERVATION_ID, I_TRIP_ID, I_NUM_PERSONS, I_TRIP_PRICE
FROM
RESERVATION
WHERE
CUSTOMER_NUM = I_CUSTOMER_NUM;
DBMS_OUTPUT.PUT_LINE(‘RESERVATION_ID, TRIP_ID, NUM_PERSONS, TRIP_PRICE’);
DBMS_OUTPUT.PUT_LINE(I_RESERVATION_ID|| ‘ , ’ ||I_TRIP_ID||‘ , ’ ||I_NUM_PERSONS|| ‘ , ’ ||I_TRIP_PRICE);
END;

3)
PUBLIC FUNCTION DEL_GUIDE (I_GUIDE_NUM)
DIM strStmt AS STRING
strStmt = “DELETE FROM GUIDE WHERE GUIDE_NUM = ’”
strStmt = strStmt & I_GUIDE_NUM
strStmt = strStmt & “’”
DoCmd.RunSQL strStmt
End Function

4)
CREATE OR REPLACE PROCEDURE UPDT_MAX_GRP(
I_TRIP_ID IN TRIP.TRIP_ID%TYPE,
I_MAX_GRP_SIZE IN TRIP.MAX _GRP_SIZE%TYPE)
AS
BEGIN
UPDATE TRIP SET MAX_GRP_SIZE=‘I_MAX_GRP_SIZE’ WHERE TRIP_ID=‘I_TRIP_ID’;
END;

5)
CREATE OR REPLACE TRIGGER TRG_INS_RESV
AFTER INSERT ON RESERVATION FOR EACH ROW
BEGIN
UPDATE TRIP SET TOTAL_PERSONS = TOTAL_PERSONS + :NEW.NEW_PERSONS WHERE TRIP_ID = :NEW.TRIP_ID;
END;

Answer 1

I... uh... won't really be able to help here, but in Q1, line 6, you have "SELECT FIST..." instead of "SELECT FIRST..."

Otherwise, you can try them one at a time or do a 50/50 elimination (remove half, test, then test the removed half).

Once you narrow it down to (hopefully) 1 query, you could try posting the error message with just that query.
I think this is called getting "the smallest reproducible case".

Answer 2

I agree with @Kirk, you need to test the cases individually, and btw, point #3) Is a Basic function, it does invoke SQL command, but if there's a problem it's more likely lies on the SQL command, as the Basic function is only executing, anyway, are those accented quotes intentional?

It would be helpful if you can also post the table structures, is this for travel agency system? idk much Oracle though.

Answer 3

I thought copy+paste got around this for me once, but might be something else :)

Answer 4

I'll tell the secret to anybody who'll help me with this :)

I have a super-small databases (3xless then 1mb) so if you can run it on your Oracle, it might be easier to find a problem. Just give me your email