LIKE clause in PL/SQL

[orauser73]

Hi,
Need help in this. I have a procedure which is passed a varchar parameter. It needs to do a SELECT on a table to get all rows where Name like the passed name. Here is a code I wrote:

PROCEDURE GET_NAME
(
p_name IN VARCHAR2
,p_cursor OUT dnCursor
)

IS

BEGIN
OPEN p_cursor FOR
SELECT
* FROM Table WHERE Name LIKE '%' + p_name + '%'
END GET_NAME;

This returns a invalid number error.

Whats wrong here..

Please advise
Thanks
orauser