Retrieve SID name within Stored Procedure

[rhasson]

I am trying to compile the following stored procedure and getting the following error:

PL/SQL: SQL Statement ignored
PLS-00201: identifier 'SYS.V_$DATABASE' must be declared

CREATE OR REPLACE PROCEDURE get_sid_name AS

-- Declare

lv_sid_name varchar2(9);

Begin

SELECT name
INTO lv_sid_name
FROM v$database;

DBMS_OUTPUT.PUT_LINE(lv_sid_name);

End;
/

I can run the SELECT minus the INTO clause in SQLPLUS and have no problems retrieveing the SID name. Can anyone think of a reason of why the code above would not compile???