Geek asks and answers

What are the parameters IN, OUT, IN OUT in PL / SQL

I searched for questions here, and also watched online and watched the video, but I'm still confused about exactly what IN, OUT is. The reason I ask is because I am writing a procedure that logs an error based on the IN parameters in other procedures,

Hooray!

0
source share
1 answer

The Oracle documentation here explains pretty well:

Parameter mode indicates whether the parameter passes data to the procedure ( IN), returns data from the procedure ( OUT), or can perform both ( IN OUT).

And about the OUTparameters:

... . , , .

, , ( SQL * Ada).

: 8-1 PL/SQL.

IN :

  • .

  • : , , .

  • , , .

  • .

OUT:

  • .

  • .

  • . NULL, NULL.

  • , . Oracle , .

  • NULL, , NOT NULL.

  • ; NOCOPY, .

IN OUT:

  • .

  • .

  • : , . Oracle , .

  • ( ).

  • ( ); NOCOPY, .

+4

More articles:


All Articles