Showing posts with label psp. Show all posts
Showing posts with label psp. Show all posts

Monday, March 19, 2012

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 youLast 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&lr=&ie=UTF-8&oe=UTF-8&threadm=1e2f54c1.0106290422.5029eb80%40posting.goo gle.com&rnum=1&prev=/groups%3Fq%3Doracle%2Bpsp%2Bvs%2Bweb%2Bpl/sql%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D1e2f54c1.0106290422.5029eb80%2540postin g.google.com%26rnum%3D1

I hope I have been of some help.

Regards

Edwin|||this page may also help you

http://www.orafaq.com/faqmodpl.htm#CONFIG|||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.|||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|||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|||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