can some one explain me this

Aravind Kumar Sekar

OK, I am new to pl/SQL, apex so I am trying to do simple program

Thanks you somuch

Lothar Flatz

The point is that this function is not needed in the database. You can simply replace it with :new:created := user; as Kim mentioned.

Alternatively if you do not want or can not change the code you can create a subsititute function for v on the database like this

create or replace function v (p_name varchar2)

IS

BEGIN

   RETURN user;

END;

KayK

it's called Oracle - it knows everything ;-)

BluShadow

Lothar Flatz wrote:

The point is that this function is not needed in the database. You can simply replace it with :new:created := user; as Kim mentioned.

Alternatively if you do not want or can not change the code you can create a subsititute function for v on the database like this

create or replace function v (p_name varchar2)
IS
BEGIN
   RETURN user;
END;

Really?

User is the database user.

v('APP_USER') in apex provides the application user, which may have been authenticated through Active Directory or some other authentication scheme, and is most certainly not likely to be a database user.

Before making changes, it's important to know what the intention and requirement is.