8 Replies Latest reply: Feb 19, 2013 12:13 AM by Billy~Verreynne RSS

    about .psp reports in oracle database 10gr2

    Kalpataru
      Hi all,
      I want to create the .psp(pl/sql ser pages) reports in the oracle database 10gr2.
      but i am unable to do it why because it needs http server(knew by going through some of the oracle docs but not able to understand) where i find this
      first of all details configuration needed for the .psp files.

      please give me the step by step details about the .psp files
        • 1. Re: about .psp reports in oracle database 10gr2
          jeneesh
          Did you check the Docs?
          • 2. Re: about .psp reports in oracle database 10gr2
            Kalpataru
            the docs you have provided i have seen
            while reading i found that the main which is required for pl/sql server page(.psp page)
            the oracle HTTP server where i found this software.
            is it coming with oracle 11g forms & web-logic server.
            is it work with oracle database software 10gr2.

            i want to know what are the software i need to install for the .psp page development.




            please replay
            • 3. Re: about .psp reports in oracle database 10gr2
              Billy~Verreynne
              extreme wrote:
              I want to create the .psp(pl/sql ser pages) reports in the oracle database 10gr2.
              Horrible outdated method for developing PL/SQL web applications.

              Not even sure whether Oracle actively supports this technology and product. It was never widely used.

              Apex (Application Express) is widely used, and have been for many years now. It is a mature product, powerful enough for professional corporate web applications (Oracle uses it, itself), and yet easy enough for a person to use, without understanding exactly what stateless web based client server works, what optimistic locking is, and how to deal with security and session state.

              Apex is by default included in Oracle 11g.

              See {thread:id=2495613} for a very recent discussion on this topic.
              • 4. Re: about .psp reports in oracle database 10gr2
                Kalpataru
                but apex is come with .zip file i have downloaded it but i will not find any setup
                file in it .
                i have loaded oracle forms 11gr2 which is come with oracle http server but the when i click on the oracle http server it is not starting with his shortcut.
                can i can create .psp files in notepad and i want access these .psp files through the url.

                but it is possible with oracle http server


                please guide me the from scratch to the end.
                • 5. Re: about .psp reports in oracle database 10gr2
                  BluShadow
                  extreme wrote:
                  please guide me the from scratch to the end.
                  Surely you jest?
                  Learning PL server pages and XSQL etc. is something our team learnt by enrolling at Oracle university for a 3 day intensive course.
                  And you expect volunteers here to guide you through that much material on the forums? I don't think you'll get that wish.
                  • 6. Re: about .psp reports in oracle database 10gr2
                    Billy~Verreynne
                    extreme wrote:
                    but apex is come with .zip file i have downloaded it but i will not find any setup
                    file in it .
                    That is because the install file is a SQL script that installs Apex (PL/SQL code and tables) into an existing database.

                    Apex manuals:
                    - Application Express Release Notes
                    - Application Express Installation Guide
                    - 2 Day + Application Express Developer's Guide
                    - Application Express Application Builder User's Guide
                    - Application Express Migration Guide
                    - Application Express Administration Guide
                    - Application Express SQL Workshop Guide
                    - Application Express API Reference
                    - Application Express End User's Guide

                    http://docs.oracle.com/cd/E23903_01/doc/index.htm
                    • 7. Re: about .psp reports in oracle database 10gr2
                      Kalpataru
                      i have read some of the docs and successfully installed the apex 4.2.

                      (i have also create a workspace in apex/oracle.com but it is required the internet connection)

                      how can i develop the web pl/sql app using apex 4.2
                      which i have installed in my pc.
                      can anyone guide me or i need some of the demo of a domi web pl/sql app.
                      • 8. Re: about .psp reports in oracle database 10gr2
                        Billy~Verreynne
                        Apex comes with demo applications - that can be installed by an Apex workspace administrator, into the existing workspace.

                        Also, Apex demo applications can be downloaded from apex.oracle.com and installed by Apex workspace developers.

                        Apex questions need to be asked in the {forum:id=137} forum.