2 Replies Latest reply: Jun 23, 2014 6:07 AM by Billy~Verreynne RSS

    Message Queue in oracle APEX

    Sruthi Tamiri


      Hi Team,

       

        There was request fro  our users to check feasibility to bevelop/to call message queue using oracle apex.

        Could some one help  me on this request, weather it can be do-able or not in apex.

       

      Apex-4.2 version wer are uisng now

      Orcale-11g

      IE#10

       

      Regards,

      Sruthitamiri

        • 1. Re: Message Queue in oracle APEX
          fac586

          Sruthi Tamiri wrote:

           

            There was request fro  our users to check feasibility to bevelop/to call message queue using oracle apex.

            Could some one help  me on this request, weather it can be do-able or not in apex.

          What do you mean by "bevelop[sic]/to call message queue"?

           

          APEX is used to create web-based applications. A "message queue" sounds like a server-based component that would be created in the database or application server: Developing Applications with the Publish-Subscribe Model

          • 2. Re: Message Queue in oracle APEX
            Billy~Verreynne

            Not a very meaningful question...

             

            Oracle RDBMS has a stored procedure language called PL/SQL.

             

            It also has a product feature called Oracle AQ (Advance Queues). This has a PL/SQL interface (enabling creating and consuming queues using PL/SQL code).

             

            It also has a product feature called APEX - which consists of PL/SQL code and database objects, enabling you use and execute (via a web based client) database objects and database stored procedure code.

             

            So obviously APEX applications can make use of the AQ interface - as they can make use of various other PL/SQL interfaces that is available.

             

            However, whether something is technically "possible" is not the first question to ask in the business analysis stage. The purpose is first to comprehensively and accurately identify and document business requirements - after which, in the technical specifications stage, one decides on how to address these requirements technically. And whether a messaging system is actually needed and if so, what technical features are needed to meet the business's functional specifications.