Questions tagged [mod-plsql]

MOD_PLSQL is an Oracle HTTP Server (Apache) extension module that allows developers to create dynamic web pages from PL/SQL packages and stored procedures within the database.

MOD_PLSQL is an Oracle HTTP Server (Apache) extension module that allows developers to create dynamic web pages from PL/SQL packages and stored procedures within the database.

37 questions
0
votes
1 answer

pl/sql duplicating many to many data

I'm kind of reverse engineering the my DB for business purposes, I'll keep this short and simple.I have two tables(a_visit,b_visit) and bridging table(a_to_b_visit) with foreign key id's from both. I need to duplicate insert into A_visit,b_visit…
user501307
  • 59
  • 1
  • 2
  • 9
0
votes
1 answer

Oracle's WDB_GATEWAY_LOGOUT does not work in mozilla browser

I have a PL/SQL application which has a log out button with following code being executed when log out button is clicked: -- Open the HTTP header owa_util.mime_header('text/html', FALSE, NULL); -- Send a cookie to…
K.I
  • 568
  • 1
  • 6
  • 19
0
votes
1 answer

Apache server and MOD_PLSQL with PHP

I'm using Apache, PHP and Oracle based application. The apache using MOD_PLSQL. But application only accessed through PHP. Is that MOD_PLSQL necessary for PHP to connect with oracle? The oracle have many procedure which is used through PHP. I want…
guru
  • 309
  • 1
  • 3
  • 15
0
votes
1 answer

Create a Webservice using PL-SQL that accepts JSON or XML type input parameters

Basically I want to create a REST Web Service using PL-SQL in Oracle and following are my requirements It should accept string parameter. That string parameter could a JSON format string or XML data It should not accept any parameters on the URL.…
Harshad
  • 21
  • 1
0
votes
2 answers

Oracle - Apache PL/SQL Gateway Module - mod_owa - access remote server

I have an Ubuntu 13.10 VM that I've created using Vagrant. This is meant to be a local development environment for a remote application using Oracle 11g and Oracle Fusion Middleware 11g. What I want to do is, clone the application's code repository…
Radu
  • 1,159
  • 3
  • 22
  • 40
0
votes
1 answer

Debugging Pl/SQL code in conjuction with SQL Developer and Oracle HTTP Server

Anybody have experience about conjunction Oracle Http Server and sql developer. I have web application that use pl/sql mod for get data. For example function flist() { var p=new revWindow("_chlist","dialogHeight: 450px; dialogWidth: 650px;…
ADZ
  • 1
  • 2
-1
votes
1 answer

oracle sql statement to get counts with pivot, group by or windowing? oracle 11g

Is it possible to and can someone please give me a good example of selecting in one query a result set that returns counts for demographics or other things group by a certain grouping? That really sound cryptic so I am going to add an example output…
1 2
3