PL/SQL (MOSC)

MOSC Banner

[Error] Compilation (533: 5): PLS-00103: Encountered the symbol "end-of-file" when expecting one of

edited May 17, 2025 6:24AM in PL/SQL (MOSC) 11 commentsAnswered

PROCEDURE GetDistinctCustomers
AS
CURSOR customer_cursor IS
SELECT DISTINCT WHSE_NUMBER, SHORT_BASE_NAME, CUSTOMER_NAME
FROM afsv.afsv_pv_mtf
WHERE CUSTOMER_NAME NOT IN
(SELECT CUSTOMER_NAME FROM afsv.afsv_pv_contact);

        v_whse_number       afsv.afsv_pv_mtf.WHSE_NUMBER%TYPE;
v_short_base_name afsv.afsv_pv_mtf.SHORT_BASE_NAME%TYPE;
v_customer_name afsv.afsv_pv_mtf.CUSTOMER_NAME%TYPE;
v_count NUMBER;
BEGIN
FOR rec IN customer_cursor
LOOP
SELECT COUNT (*)
INTO v_count
FROM afsv.afsv_pv_mtf
WHERE WHSE_NUMBER = rec.WHSE_NUMBER
AND SHORT_BASE_NAME = rec.SHORT_BASE_NAME

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center