![]() ![]() Typically, you set a returned value for the OUT parameter and return it to the calling program. It means that if you don’t specify the mode for a parameter explicitly, Oracle will use the IN mode.Īn OUT parameter is writable. You can reference an IN parameter inside a procedure, but you cannot change its value. The parameter mode specifies whether a parameter can be read from or write to.Īn IN parameter is read-only. IS Code language: SQL (Structured Query Language) ( sql )ĮND PL/SQL procedure headerĪ procedure begins with a header that specifies its name and an optional parameter list.Įach parameter can be in either IN, OUT, or INOUT mode. CREATE PROCEDURE procedure_name (parameter_list)
0 Comments
Leave a Reply. |