Forum Stats

  • 3,876,212 Users
  • 2,267,082 Discussions
  • 7,912,473 Comments

Discussions

can some one explain me this

13»

Answers

  • Aravind Kumar Sekar
    Aravind Kumar Sekar Member Posts: 27
    edited Sep 16, 2015 4:51AM

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

    Thanks you somuch

  • Lothar Flatz
    Lothar Flatz Member Posts: 687 Silver Badge
    edited Sep 16, 2015 5:08AM

    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
    KayK Member Posts: 1,742 Bronze Crown
    edited Sep 16, 2015 5:30AM

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

    Chris Hunt
  • BluShadow
    BluShadow Member, Moderator Posts: 42,591 Red Diamond
    edited Sep 16, 2015 5:36AM
    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.

    William Robertson
This discussion has been closed.