How to pass item value to oracle function in oracle application express?

1
votes

I have item in oracle apex 

P12_MOBILE_NUMBER

on form load I am fetching data using fetch row from and set to different items. Once mobile number set to item P12_MOBILE_NUMBER, I want to pass its item value to oracle function and function returned value set to P12_MOBILE_NUMBER again .

I can call my function like

Select stars(mobile_number)as mobile_number from dual;

Please help me out how can I do that , I am using application express 18.2

1
oracleoracle11goracle-apexoracle-apex-5oracle-apex-5.1

1 Answers

1
votes

Create a Page Load dynamic action:

  • set its True action to "Execute PL/SQL Code"

  • that code would be 

    :P12_MOBILE_NUMBER := stars(:P12_MOBILE_NUMBER);
  • Items to submit: P12_MOBILE_NUMBER
  • Items to return: P12_MOBILE_NUMBER

Run the page; automatic row fetch will fetch row value, and page load dynamic action will modify the mobile number (based on what your function actually does).