5 Replies Latest reply: Feb 19, 2013 7:14 AM by brian.mcginity RSS

    mod_plsql app in the cloud??

    brian.mcginity
      I have written a custom mod_plsql application and am wondering if I can move it the Oracle Cloud. I do not use any APEX whatsoever.

      For this to work, the cloud service would need to provide:
      -     The ability to create 2 schema users
      -     The ability to grant permissions between the schema owners
      -     The ability to create synonyms (private is ok)
      -     The ability for the dad to be set to Custom OWA so it calls myschema.owa_custom.authroize() at each page request
      -     The ability to create a procedure my hello_world procedure (below)
      -     The ability to access the procedure via a url
      - 500k-1MM page hits per day
      CREATE OR REPLACE PROCEDURE hello_world  AS 
      
      BEGIN 
      
      htp.p(‘
      
              <html>
           <head></head>
           <body>this is a test</body>
           </html>     
      ’);
      
      owa_util.print_cgi_env;
        
      
      END;
      For some of the items in check list, I may have some flexibility.
        • 1. Re: mod_plsql app in the cloud??
          brian.mcginity
          Oracle Sales directed me to this forum for technical questions. I guess they think that someone from Oracle is answering questions here. Is my question too complex?
          • 2. Re: mod_plsql app in the cloud??
            Rod West
            Hi,

            The Oracle Database Cloud Service can provide some but not all of the features you require.
            The ability to create 2 schema users
            Not possible, each cloud service has access to just one schema.
            The ability to grant permissions between the schema owners
            You cannot grant permissions, see above.
            The ability to create synonyms (private is ok)
            You cannot create synonyms.
            The ability for the dad to be set to Custom OWA so it calls myschema.owa_custom.authroize() at each page request
            You cannot create a callback owa_custom.authorize. However, you have OUATH2 authentication which will allow you to create your own security based on the user id for each request.
            The ability to create a procedure my hello_world procedure (below)
            You can create procedures which generate HTML using the htp package. You also have access to the OWA pakages.
            The ability to access the procedure via a url
            You can access the procedure via a url using a RESTful web service with PL/SQL source type. See this document (http://www.oracle.com/technetwork/database/database-cloud/public/restful-wp-1844130.pdf) for more details.
            500k-1MM page hits per day
            The hits per day is not a problem, the maximum data transfer is controlled by the level of service you purchase.

            Rod West
            • 3. Re: mod_plsql app in the cloud??
              brian.mcginity
              Thank you Rod for following up.

              Does Oracle offer any other type of hosting where I could have more flexibility inside of the database and also have a web server running apache / mod_plsql?

              Edited by: brian.mcginity on Jan 31, 2013 12:08 PM
              • 4. Re: mod_plsql app in the cloud??
                RickG
                Brian -

                You might want to investigate Oracle Managed Cloud Services, formerly known as Oracle OnDemand. Thanks for your interest.

                - Rick Greenwald
                • 5. Re: mod_plsql app in the cloud??
                  brian.mcginity
                  Thank you.