pl/sql

From: D.j <dec2g_at_hotmail.com>
Date: Fri, 29 Oct 2004 15:41:19 -0400
Message-ID: <i3xgd.20$QK5.765_at_eagle.america.net>

[Quoted] I am tring to run this code:

CREATE OR REPLACE PROCEDURE DISPLAY_CUSTOMER_INFO(

						   P_CUSTOMER NUMBER
							) IS



V_CUSTREC	CUSTOMERS%ROWTYPE;
V_SALES_REP	VARCHAR2(255);
V_ORDERS_CNT	NUMBER(6);
V_ORDERS_AMT	NUMBER;

BEGIN

	BEGIN
		SELECT *
			INTO V_CUSTREC
			FROM CUSTOMERS
			WHERE CUSTOMER_ID = P_CUSTOMER;
	EXCEPTION
		WHEN NO_DATA_FOUND THEN
			RAISE_APPLICATION_ERROR(-20000, 'CUSTOMER DOES NOT EXIST');
	END;

	SELECT FIRST_NAME || '' || LAST_NAME
		INTO V_SALES_REP
		FROM EMPLOYEES
		WHERE EMPLOYEE_ID = V_CUSTREC.SALES_REP_ID;

	SELECT COUNT(*)
		INTO V_ORDERS_CNT
		FROM ORDERS
		WHERE CUSTOMER_ID = P_CUSTOMER;

	SELECT SUM(TOTAL_AMOUNT)
		INTO V_ORDERS_AMT
		FROM ORDER_LINES
		WHERE ORDER_ID IN (SELECT ORDER_ID
					FROM ORDERS
					WHERE CUSTOMER_ID = P_CUSTOMER);

	DBMS_OUTPUT.PUT_LINE('CUSTOMER NAME:  ' ||
				V_CUSTREC.FIRST_NAME||' '||
				V_CUSTREC.LAST_NAME);
	DBMS_OUTPUT.PUT_LINE('CUSTOMER PHONE:  ' || V_CUSTREC.PHONE);
	DBMS_OUTPUT.PUT_LINE('CUSTOMER STATUS: ' || V_CUSTREC.STATUS);
[Quoted] 	DBMS_OUTPUT.PUT_LINE('NUMBER OF ORDERS: ' || V_ORDERS_CNT);
	DBMS_OUTPUT.PUT_LINE('ORDERS AMOUNT: ' || V_ORDERS_AMT);
	END;
  	/

I keep getting this error:

SQL> _at_a:\plsql2.sql
  48 /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE DISPLAY_CUSTOMER_INFO:

LINE/COL ERROR
-------- -----------------------------------------------------------------
47/3 PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.

SQL> show errors
Errors for PROCEDURE DISPLAY_CUSTOMER_INFO:

LINE/COL ERROR
-------- -----------------------------------------------------------------
47/3 PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.

SQL> _at_a:\plsql2.sql

SP2-0734: unknown command beginning "V_CUSTREC  ..." - rest of line ignored.
SP2-0734: unknown command beginning "V_SALES_RE..." - rest of line ignored.
SP2-0734: unknown command beginning "V_ORDERS_C..." - rest of line ignored.
SP2-0734: unknown command beginning "V_ORDERS_A..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.
  39
  40 ;
  41
  42 /

         /
         *

ERROR at line 38:
ORA-06550: line 38, column 3:
PLS-00103: Encountered the symbol "/"

SQL> _at_a:plsql2.sql
  50
  51 /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE DISPLAY_CUSTOMER_INFO:

LINE/COL ERROR
-------- -----------------------------------------------------------------
49/3 PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.

SQL> _at_a:\plsql2.sql
  50 /
CREATE PROCEDURE DISPLAY_CUSTOMER_INFO(

                  *

ERROR at line 1:
ORA-00955: name is already used by an existing object

SQL> _at_a:\plsql2.sql

SP2-0734: unknown command beginning "REPLACE PR..." - rest of line ignored.
SP2-0734: unknown command beginning "P_CUSTOMER..." - rest of line ignored.
SP2-0042: unknown command ") IS" - rest of line ignored.
SP2-0734: unknown command beginning "V_CUSTREC  ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "V_SALES_RE..." - rest of line ignored.
SP2-0734: unknown command beginning "V_ORDERS_C..." - rest of line ignored.
SP2-0734: unknown command beginning "V_ORDERS_A..." - rest of line ignored.
  39  /
         /
         *

ERROR at line 38:
ORA-06550: line 38, column 3:
PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.

SQL> _at_A:\plsql2.sql
  50 /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE DISPLAY_CUSTOMER_INFO:

LINE/COL ERROR
-------- -----------------------------------------------------------------
49/3 PLS-00103: Encountered the symbol "/" The symbol "/" was ignored. Received on Fri Oct 29 2004 - 21:41:19 CEST