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

No comments:

Post a Comment