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












1















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










share|improve this question





























    1















    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










    share|improve this question



























      1












      1








      1








      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










      share|improve this question
















      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







      oracle oracle11g oracle-apex oracle-apex-5 oracle-apex-5.1






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Dec 29 '18 at 7:48









      A.H.Nuri

      813510




      813510










      asked Dec 29 '18 at 5:52









      AbdulRaheemAbdulRaheem

      254




      254
























          1 Answer
          1






          active

          oldest

          votes


















          1














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






          share|improve this answer
























          • just like a boss

            – AbdulRaheem
            Dec 29 '18 at 7:00











          • can you please share your email adress and skypeid if you don't mind

            – AbdulRaheem
            Dec 29 '18 at 7:01











          • Sorry, I'd like to keep that info private. But I'll be glad to assist if you have any questions and post them here (and if I know the answer, of course).

            – Littlefoot
            Dec 29 '18 at 18:26











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53967075%2fhow-to-pass-item-value-to-oracle-function-in-oracle-application-express%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          1














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






          share|improve this answer
























          • just like a boss

            – AbdulRaheem
            Dec 29 '18 at 7:00











          • can you please share your email adress and skypeid if you don't mind

            – AbdulRaheem
            Dec 29 '18 at 7:01











          • Sorry, I'd like to keep that info private. But I'll be glad to assist if you have any questions and post them here (and if I know the answer, of course).

            – Littlefoot
            Dec 29 '18 at 18:26
















          1














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






          share|improve this answer
























          • just like a boss

            – AbdulRaheem
            Dec 29 '18 at 7:00











          • can you please share your email adress and skypeid if you don't mind

            – AbdulRaheem
            Dec 29 '18 at 7:01











          • Sorry, I'd like to keep that info private. But I'll be glad to assist if you have any questions and post them here (and if I know the answer, of course).

            – Littlefoot
            Dec 29 '18 at 18:26














          1












          1








          1







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






          share|improve this answer













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







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Dec 29 '18 at 6:15









          LittlefootLittlefoot

          21k71433




          21k71433













          • just like a boss

            – AbdulRaheem
            Dec 29 '18 at 7:00











          • can you please share your email adress and skypeid if you don't mind

            – AbdulRaheem
            Dec 29 '18 at 7:01











          • Sorry, I'd like to keep that info private. But I'll be glad to assist if you have any questions and post them here (and if I know the answer, of course).

            – Littlefoot
            Dec 29 '18 at 18:26



















          • just like a boss

            – AbdulRaheem
            Dec 29 '18 at 7:00











          • can you please share your email adress and skypeid if you don't mind

            – AbdulRaheem
            Dec 29 '18 at 7:01











          • Sorry, I'd like to keep that info private. But I'll be glad to assist if you have any questions and post them here (and if I know the answer, of course).

            – Littlefoot
            Dec 29 '18 at 18:26

















          just like a boss

          – AbdulRaheem
          Dec 29 '18 at 7:00





          just like a boss

          – AbdulRaheem
          Dec 29 '18 at 7:00













          can you please share your email adress and skypeid if you don't mind

          – AbdulRaheem
          Dec 29 '18 at 7:01





          can you please share your email adress and skypeid if you don't mind

          – AbdulRaheem
          Dec 29 '18 at 7:01













          Sorry, I'd like to keep that info private. But I'll be glad to assist if you have any questions and post them here (and if I know the answer, of course).

          – Littlefoot
          Dec 29 '18 at 18:26





          Sorry, I'd like to keep that info private. But I'll be glad to assist if you have any questions and post them here (and if I know the answer, of course).

          – Littlefoot
          Dec 29 '18 at 18:26


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53967075%2fhow-to-pass-item-value-to-oracle-function-in-oracle-application-express%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Monofisismo

          Angular Downloading a file using contenturl with Basic Authentication

          Olmecas