CODEWITHSUNDEEP
databaseoracle-databaseplsqlsyntax
Yogesh Thapliyal
Yogesh Thapliyal

Reputation: 71

can we use a function while accepting parameters in oracle procedure

I need to ensure that the parameter "lastname" that is being passed to my Oracle procedure is in "initcap" format. Can I use the INITCAP function while accepting the value itself?

create or replace PROCEDURE SP_SPRIDEN_7_INSERT
 (
 PIDM in varchar2,
 STUD_ID IN OUT VARCHAR2,
 INITCAP(LASTNAME) IN VARCHAR2,
 ERROR OUT VARCHAR2
)

Upvotes: 2

Views: 58

Answers (1)

Mureinik
Mureinik

Reputation: 311143

You can't define a procedure like this. The easiest way to get this behavior is to explicitly call initcap on that argument before using it in the procedure's body.

Upvotes: 1

Related Questions