Who's Online
0 registered (), 3 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Update EIT in SSHR
by Sahir
03:45 PM
End of Year Legislation Patch for 11i
by delboy
01:35 PM
Interfacing iRec and external sites
by DanC
11:42 PM
Capturing, Storing, & Paying Banked Overtime
by Paul
08:51 PM
Time and Labour & Oracle Projects
by Paul
07:34 PM
Search Engine Optimizers
by delboy
01:30 PM
Abseces in oracle hrms, super user: how to do I:
by JayTee
07:26 AM
Function for getting retropay-maintained balances
by CT
08/02/12 12:21 PM
Grade End Date
by Chris
03/02/12 10:46 AM
OLM Mandatory Enrolments
by bcooper
01/02/12 12:23 PM
Top Posters (30 Days)
CT 26
delboy 25
bcooper 15
Sahir 5
Gus 5
tovia123 4
Tim Bailey 3
christm 3
SBi 3
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 18216
CREATE_GRADE api returns:PLS-00306: wrong number o 13757
Still trying to locate... 12193
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 10646
Viewing Output of another user 9131
HR_PF.K RUP4 8841
Review of my Release 12 laptop 8494
Adding a taskflow button to a form 7855
Enhanced Retro & Release 12 7679
Family Pack K 7116
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#5631 - 23/07/10 06:35 AM Upgrade to R12 with Web PL/SQL
GregF Offline
regular

Registered: 14/03/05
Posts: 25
Loc: Cape Town
Hi all

I've a client who is in the process of trying to upgrade to R12. They've engaged a consultancy (for the sake of this question, lets call them Vampire Consultancy...) to do the upgrade, which seems to be going well, except for one major issue... (Funnily enough, the reason they engaged this consultancy was for this issue, but thats besides the point...).

The issue is that the client has a number of modules that were written in web pl/sql - some pretty big stuff like a Share Scheme which practically cannot be re-written within reasonable timeframes. You probably know that Oracle R12 no longer supports web pl/sql, hence the problem.

There are some notes on Metalink which talk about how to run web pl/sql in R12 - however the Vampires are not making any progress.

And my question is: Has anybody out there managed to get web pl/sql working on R12?

Top
#5890 - 05/10/10 08:09 PM Re: Upgrade to R12 with Web PL/SQL [Re: GregF]
sridhardumbala Offline
stranger

Registered: 05/10/10
Posts: 2
To my knowledge oracle is not supporting mod_plsql with r12 architecture, but that dosen't necessarily mean we can not run PL/SQL Web Application built using web pl/sql (pl/sql web tool kit).

Its my impression that we can still run these application by not using Oracle HTTP Server but instead use an Apache server.

Please educate me as well on this, if you have any other information.

Top
#5894 - 06/10/10 07:58 AM Re: Upgrade to R12 with Web PL/SQL [Re: sridhardumbala]
bcooper Offline

Guru
*****

Registered: 11/03/05
Posts: 1095
Loc: Earth, Europe, England, here
Not sure you can run Oracle HTTP Server and Apache on the same mid-tier box

Unless there is a custom work-around that mimic's the functionality of the mod_plsql plugin within HTTP Server...

I'm sure Oracle would recommend any apps written in web pl/sql being migrated (read Rewritten) in something like APEX / ADF Faces etc
_________________________
HCM Aces is for sale! Please contact me if you are interested.
Also my random musings courtesy of Twitter

Top
#5897 - 08/10/10 01:26 PM Re: Upgrade to R12 with Web PL/SQL [Re: bcooper]
AlexChard Offline
enthusiast

Registered: 15/09/05
Posts: 41
Loc: Leamington Spa
I've got mod_plsql working on R12 previously. I even went through the process as an SR with Oracle, only for them to decide it wasn't something they were going to support.
I've got set up document at home. If you would like a copy, send me a private message with an email address, and I'll fire it over to you.

Alex
_________________________
Oracle EBS Contractor

Top
#5900 - 11/10/10 01:08 PM Re: Upgrade to R12 with Web PL/SQL [Re: AlexChard]
surfergirlcut Offline
passing stranger

Registered: 11/10/10
Posts: 1
I would love a copy please.thank you
surfergirlcut@yahoo.com

Top
#5917 - 19/10/10 08:35 AM Re: Upgrade to R12 with Web PL/SQL [Re: surfergirlcut]
AlexChard Offline
enthusiast

Registered: 15/09/05
Posts: 41
Loc: Leamington Spa
Originally Posted By: surfergirlcut
I would love a copy please.thank you
surfergirlcut@yahoo.com

Email sent last week.
_________________________
Oracle EBS Contractor

Top
#6274 - 13/01/11 10:52 PM Re: Upgrade to R12 with Web PL/SQL [Re: AlexChard]
kandsan Offline
stranger

Registered: 13/01/11
Posts: 3
I would like to have a copy please. Thank you.

Top
#6481 - 25/03/11 01:27 AM Re: Upgrade to R12 with Web PL/SQL [Re: AlexChard]
gor Offline
passing stranger

Registered: 25/03/11
Posts: 1
I would like to have a copy please. Thank you.
guochangming1984@163.com

Top
#6712 - 21/06/11 03:32 PM Re: Upgrade to R12 with Web PL/SQL [Re: AlexChard]
Foued Offline
passing stranger

Registered: 21/06/11
Posts: 1
Can you please send a copy?

fouedhassen@yahoo.com

Thank you,
Foued

Top
#6810 - 06/08/11 01:44 PM Re: Upgrade to R12 with Web PL/SQL [Re: AlexChard]
Beshara Offline
passing stranger

Registered: 06/08/11
Posts: 1
Pl send the setup document. Thank you.

munaaf@yahoo.com

Top
Page 1 of 2 1 2 >



Moderator:  Administrator 
Forum Stats
756 Members
48 Forums
1517 Topics
7286 Posts

Max Online: 63 @ 24/11/10 07:21 AM
Today's Birthdays
No Birthdays
Recent vacancies
Tea boy available 4 basic chores & some! services
by Simon_Mc
19/01/12 03:59 PM
Top Posters
bcooper 1095
CT 1080
delboy 500
Geoff Dixon 369
SBi 344
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 160
Gus 132
February
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29