This content has been marked as final. Show 6 replies
There are so many errors in this small example of code you posted that I highly recommend that you visit a training course or work yourself through a good pl/sql book going through given examples.
This would at last help you much more than trying without any guidance (and save us from being misused as a gratis teacher).
An out parameter is supposed to 'return' a value.
execute the block given below:
and change the order of columns in the select statement..
Message was edited by:
As I know we need to pass value only for IN parameters and not for OUT parametersOf course it's not so, as you can see on your second try.
The second error is rather self-explanatory : you can't use parameters passed to the procedure as target assignments, you have to declare variables for that.
Thanks a lot Kshama & Paul.
Christian, I am sorry. Never knew that beginners cannot post any messages to this message-board.
Just to mention I do refer some Oracle books from Oracle Press but may be was not very clear on certain things.
Will take care in future.
Personally I like the chance to answer beginners questions to confirm my own knowledge.
Anyway, the way I think of it is:
IN parameter = pass in a value needed by the procedure.
OUT = pass in a variable you want the procedure to set for you.
highly recommanded :
Oracle PL/SQL Programming, 4th edition
by Steven Feuerstein, Bill Pribyl