I have some records in the Employee table. Now I compile it using f5 and it compiles successfully.
while i right click on run and the window opens I am unable to add any parameter( name which I want to send to get details)
I have attached the screenshot as wel.
ALso if I run it thru Execute Vivek.TEST_SP '<any name>'
It gives me invalid SQL statement error. Can someone pitch in and help as I want to understand stored procedures in detail and am stuck on simple SP as of now.
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).
Joined: Jul 08, 2011
Can you please provide the complete SP and how to run. I am still confused Martin.