CODEWITHSUNDEEP
oracle-databasestored-proceduresparametersinput
Anthony Accioly
Anthony Accioly

Reputation: 22461

Are parameters in a PL/SQL Stored Procedure "IN" by default?

Rephrasing the question: Are this two code snippets different in any way? 

CREATE OR REPLACE PROCEDURE 
ASSIGN_EMAIL(E_NO INT, F_NAME VARCHAR2, L_NAME VARCHAR2)

CREATE OR REPLACE PROCEDURE 
ASSIGN_EMAIL(E_NO IN INT, F_NAME IN VARCHAR2, L_NAME IN VARCHAR2)

Upvotes: 2

Views: 217

Answers (1)

Mat
Mat

Reputation: 206659

Yes, IN is the default. Check table 8.1 in the Oracle PL/SQL subprogram docs.

Upvotes: 2

Related Questions