"pls-00201 identifier must be declared" in ASP.NET/C# -

i have following stored procedure i'd use in c#/.net:

create or replace procedure contact_return(     v_urn in varchar2,     p_cursor out sys_refcursor )   sql_statement varchar2(4000) := '            select urn,     firstname,     lastname,     title,     mobile,     work,     email   contact   urn = nvl(:1,v_contact_urn)'; begin   open p_cursor sql_statement using v_urn; 

using code, en error: pls-00201: identifier 'contact_return' must declared

        oraclecommand cmd = new oraclecommand();         cmd.connection = conn;         cmd.commandtype = commandtype.storedprocedure;         cmd.commandtext = "contact_return";         cmd.parameters.add("v_urn", oracledbtype.int64).value = null;         cmd.parameters.add("p_cursor", oracledbtype.refcursor).direction = parameterdirection.output; 

as far can see, have declared stored procedure ('contact_return') correctly, cannot figure out why i'm getting error.

any appreciated, thank :)

shouldn;t

create or replace procedure contact_return(     v_urn in varchar2,     p_cursor out sys_refcursor )   sql_statement varchar2(4000) := '            select urn,     firstname,     lastname,     title,     mobile,     work,     email   contact   urn = nvl(:1,v_contact_urn)'; begin   open p_cursor sql_statement using v_urn; 

be

create or replace procedure contact_return(     v_urn in varchar2,     p_cursor out sys_refcursor ) begin   declare sql_statement varchar2(4000) := '';            select urn,     firstname,     lastname,     title,     mobile,     work,     email   contact   urn = nvl(:1,v_contact_urn)';    open p_cursor sql_statement using v_urn;  end;