CODEWITHSUNDEEP
sqloracle-databasefunctionplsqldml
abby
abby

Reputation: 41

what exactly is plsql function returning if it just return returntype

I'm having a hard time understanding the below plsql function. what exactly does the function return and what exactly does the function do?

      function getsysparm(a_name varchar2,

                          a_default varchar2 := null,

                          a_date    sys_params.date_expires%type := null) 

                  return  varchar2;

Upvotes: 0

Views: 41

Answers (2)

AndyDan
AndyDan

Reputation: 759

That's not a function, it's just a function declaration, and from the looks of it, probably in a package spec. You need to look in the package body to see the actual code for the function.

Upvotes: 1

Littlefoot
Littlefoot

Reputation: 142788

Function accepts 3 parameters: one is mandatory (a_name), while another two are optional.

It returns a string (value whose datatype is VARCHAR2), for example "Abby" or "Stack Overflow" or "x".

What does it exactly do? Who knows ... you didn't post any code. See whether

select text
from user_source
where name = 'GETSYSPARM'

returns something you could have a look at.

Upvotes: 0

Related Questions