Hi all if i can assign any value to the out parameter in procedures .... like i had created this procedure ...CREATE ORE REPLACE PROCEDURE MODETEST ( PARAMETER OUT NUMBER)ISJUSTTEST NUMBER :=20;BEGINPARAMETER :=JUSTTEST ; *HERE I ASSIGN VALUE TO OUT PARAMETER *JUSTTEST := PARAMETER;dBMS_OUTPUT.PUT_LINE(JUSTTEST);END; AND THE PROCEDURE IS CREATED WITHOUT ANY ERROR BUT I THAUGHT THE OUT PARAMETERS ARE WRITE ONLY AND WE CANT ASSIGN ANY VALUE TO IT ....

  • Interview Candidate
  • 3
  • 2156

Showing Answers 1 - 3 of 3 Answers

Brajesh Singh Bhadoriya

  • Jan 15th, 2007
 

hi...

actually the IN parameters are the read only parameters hence we can't assign any value to them but for out parameters its not true, as we can assign value to OUT parameters. so the procedure u created will cause no error as it is doin fine by assigning value in OUT parameter only.

Thanks,

Brajesh

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions