Yeah. You don't define any parameter to your procedure, I've overlooked it.
You declare the (uninitialized) local variable v_name. You probably want to declare a parameter (say, p_name) and use that in the
where condition of your
select:
Vivek Hingorani wrote:Can someone pitch in and help as I want to understand stored procedures in detail and am stuck on simple SP as of now.
You might enjoy the following link then:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/toc.htm
Also check out all the development guides:
http://www.oracle.com/pls/db111/portal.portal_db?selected=5
Oracle has really good documentation for the database. In my opinion, you don't really need other books. Be sure to read the
Concepts Guide too, though. It covers the database basics and is the most important book for anyone dealing with Oracle database. (If you're on a different version of the database, find the docs corresponding to your version).