Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    42

    Unanswered: How to Configure PSP

    HI,

    Anyone know how to configure the pl/sql server page application. iam new to this area, can you help me regarding PSP.

    Thank you

  2. #2
    Join Date
    Dec 2003
    Posts
    74
    Last time I created a PSP page was about 2 years ago. I created a HTML file with embedded PL/SQL and the used the PSP converter/uploaded to load it into the database. The upload then creates a PL/SQL procedure/package (not quite sure) in the database which can be executed via the PL/SQL mod on the IAS server. PSP was in a way their version of JSP (Java Server Pages HTML pages with Java embedded into them which when executed were converted)

    I personally used designer to design generate Web PL/SQL forms as I found it more benificial at the time.

    Maybe PSP has moved on since then have a look at this thread and see what other people think.

    http://groups.google.ie/groups?hl=en...com%26rnum%3D1

    I hope I have been of some help.


    Regards

    Edwin

  3. #3
    Join Date
    Dec 2003
    Posts
    74
    this page may also help you


    http://www.orafaq.com/faqmodpl.htm#CONFIG

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    To Develop and Deploy PL/SQL Server Pages, you need the Oracle Server 8.1.6 or later and either Oracle Application Server PL/SQL Cartridge or Oracle WebDB PL/SQL Gateway.
    SATHISH .

  5. #5
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    1. Install the PL/SQL Toolkit
    2. Create the Listener
    3. Create a Database Access Descriptor
    4. Create an Application called pspApp
    5. Add a Cartridge to your Application
    6. Create the PL/SQL Server Pages Script
    7. Load the PL/SQL Server Page
    8. Verify Procedure creation
    9. Reload OAS
    10. Execute the PSP script from OAS
    SATHISH .

  6. #6
    Join Date
    Dec 2003
    Posts
    74
    Originally posted by satish_ct
    Hi,

    To Develop and Deploy PL/SQL Server Pages, you need the Oracle Server 8.1.6 or later and either Oracle Application Server PL/SQL Cartridge or Oracle WebDB PL/SQL Gateway.
    As far as I am aware none of these products are supported.

    Can I recommend that you use version 9i or higher of the database and IAS as OAS is not as reliable and also may not be supported. IAS come with PL/SQL module in replace of the PL/SQL cartridge.

    Regards

    Edwin
    Last edited by edwinjames; 01-06-04 at 06:35.

  7. #7
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs down

    U Better check & make sure that these products are supported.

    Originally posted by edwinjames
    As far as I am aware non of these products are supported.

    Can I recommend that you use version 9i or higher of the database and IAS as OAS is not as reliable and also may not be supported. IAS come with PL/SQL module in replace of the PL/SQL cartridge.

    Regards

    Edwin
    SATHISH .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •