Technology Stack - EBS (MOSC)

MOSC Banner

How to call PLSQL Function in Condition tab of form personalization

edited Aug 20, 2021 11:08AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hi,

  I created the PLSQL function like this.

create or replace function test_func(param IN Date) return varchar2 is

ret_value varchar2(100);

begin

ret_value := to_char(TO_DATE( param , 'dd-mm-yyyy'),'Day');

return (ret_value);

end;

I would like to call this PLSQL function in Condition tab of form personalization.

May I know solution for this requirement

Best Regards,

Htet Htet

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center