I am very new to Oracle and PL/SQL. I think I have a simple mistake here but don't know what I'm doing wrong.
I'm trying to create a simple stored procedure. I am storing it in my schema(lew) but want to query tables in a schema called Oracle. This SQL statement works in SQL editor. But when I compile it I get the message PLS-00201: identifier 'ORACLE.PRODUCT' must be declared.
CREATE OR REPLACE PROCEDURE LEWTESTPROC IS
v_Code Oracle.Product.Product_Code%TYPE;
v_Description Oracle.Product.Product_Description%TYPE;
BEGIN
SELECT Oracle.Product_Description, Oracle.Product_Code
INTO v_Description, v_Code
FROM Oracle.Product
WHERE Oracle.Product_Code = 'T';
EXCEPTION
WHEN NO_DATA_FOUND THEN
Null;
WHEN OTHERS THEN
Null;
END LEWTESTPROC;
THANKS FOR YOUR HELP
