CODEWITHSUNDEEP
oracle-databaseoracle11goracle-apexoracle-apex-5oracle-apex-5.1
AbdulRaheem
AbdulRaheem

Reputation: 115

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

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

Upvotes: 1

Views: 2642

Answers (1)

Littlefoot
Littlefoot

Reputation: 142705

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).

Upvotes: 1

Related Questions