6 Replies Latest reply: Jan 11, 2014 8:11 PM by GuruKumar RSS

    The webpage cannot be found

    GuruKumar


      Hi,

          I am New to APEX, I want Your Help,

         I am Developing a Report Using Apex 4.2 .When My Plsql Query Goes Beyond 350 Lines ,I get this Error "The webpage cannot be found" . i want to know ,Only  350 Lines can be Coded In APex?

       

      Please Give Me Some Advise.

       

       

      Thanks.

        • 1. Re: The webpage cannot be found
          AndyPol

          Hi

           

          Please change your nick: e5f5d691-91aa-4edb-8299-e4e470b85249

           

          In apex you can query table with milions records : ) But if your query take more time you can got time out or other error. It's not apex case. In my opinion you have to use pagination for example on 50 rows.

          • 2. Re: The webpage cannot be found
            GuruKumar


            Hi Andy,

                        Thanks For Your Reply, My Problecm Not Seelcting Columns from Table.

            I am Writing Code (PLSQL) to Generate A Reort Using PLSQL Dynamically.

            My Code Sixe Around 31.6 KB, Now I Want To Add Some More Conditions And It Increases My Code Size to 33 Kb, now Apex Page Turns to The webpage cannot be found

            • 3. Re: The webpage cannot be found
              fac586

              e5f5d691-91aa-4edb-8299-e4e470b85249 wrote:

               

              Please Give Me Some Advise.

              Update your forum profile with a real handle instead of "e5f5d691-91aa-4edb-8299-e4e470b85249".

               

              Please supply the following information:

               

              • Full APEX version
              • Full database version/edition/host OS
              • Web server architecture (EPG, OHS or APEX listener/host OS)
              • Browser(s) and version(s) used

               

              Always include this information when asking a question.

              I get this Error "The webpage cannot be found"

              Where do you see this error: in the Application Builder when applying changes to your region source? Or from your application at runtime?

              • 4. Re: The webpage cannot be found
                GuruKumar

                Hi,

                   Sorry For the Late Reply,

                 

                I am Guru From India, I am Unable to Change My Handle.... Sorry For that.

                I am Trying to Change My Handle...

                Mean While I will Provide This Information,

                   My Full Apex Version is 4.2.3.00.08

                   My Database Version 11.2.0.3

                   Web server architecture is OHS 
                   Browser is IE 7


                And  I am Getting the Above Mentioned Error when Codded (400 lines or  33 KB) for a report and When Clicking 'Apply Changes'.


                Regards

                Guru.

                  

                • 5. Re: The webpage cannot be found
                  fac586

                  e5f5d691-91aa-4edb-8299-e4e470b85249 wrote:

                   

                   

                  And  I am Getting the Above Mentioned Error when Codded (400 lines or  33 KB) for a report and When Clicking 'Apply Changes'.  

                  The maximum size of region source that can be entered and stored in APEX is 32KB. However it is not good practice to create large static report queries or complex PL/SQL to dynamically generate a query directly in APEX. Complex static queries should be created as views in the database, and dynamic queries generated using subprograms in a PL/SQL package. As you are generating a report query dynamically, create a package to do this with a function returning the SQL text and call this function from the APEX region source.

                  • 6. Re: The webpage cannot be found
                    GuruKumar

                    HI,

                         Ok Thanks for your Idea , i will create a function to frame that SQL .

                    Thank You So Much.

                     

                    Regards

                    Guru.