Stack Overflow
Stack Overflow

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
6
votes
4 answers

How do I populate a user-defined record that has default values?

TL; DR: How can I declare a user-defined record type so that if I don't populate one of the fields, that field will honor its DEFAULT? Details: In my package spec, I define the following record and table types: /* set up a custom datatypes that…
Jeromy French
  • 11,812
  • 19
  • 76
  • 129
6
votes
4 answers

migrating mod_plsql application to Oracle REST Data Services

I read on MOS Doc ID 1945619.1 that starting with the 12.1.3 Oracle HTTP Server (OHS), the mod_plsql feature has been deprecated and will not be included with the 12.2 Oracle HTTP Server. For the future, Oracle recommends moving to Oracle REST Data…
Cristian Veronesi
  • 300
  • 1
  • 3
  • 15
4
votes
1 answer

Oracle mod_plsql does not implement PUT and DELETE HTTP requests

I am running Oracle-Application-Server-10g and using mod_plsql for webserver. While webserver accepts HTTP requests such as POST, DELETE and HEAD, I can not find a way in setting it to accept other HTTP requests such as PUT and DELETE. Sending PUT…
tomtom
  • 41
  • 1
3
votes
2 answers

Replacing mod_plsql with Oracle Rest Data Services

We are in the process of upgrading an application running on Oracle 10g and oracle HTTP server to Oracle 12C. Due to mod pl/sql being deprecated we have chosen following combination. oracle 12c + ORDS 3.0 and tomcat. (we are not using APEX) A major…
Rthemus
  • 81
  • 3
3
votes
2 answers

Am using the below Function to decrypt a code ? Could any help to resolve?

function ibp_crypto_decrypt ( p_session_id in RAW) return raw is l_decrypted_raw RAW(2048); l_encrypted_raw RAW(2048) := p_session_id; l_key RAW(128) :=…
Ranjith Kumar
  • 51
  • 2
  • 5
3
votes
1 answer

PL/SQL ExcelDocumentType document name wrong

I am using Jason Bennet's ExcelDocumentType document api to create a spreadsheet using pl/sql (http://www.jasonsdevelopercorner.com/?page_id=8). I am displaying the spreadsheet via a DAD (dads.conf). Generating my spreadsheet content via pl/sql is…
Richie
  • 4,989
  • 24
  • 90
  • 177
2
votes
2 answers

PL/SQL (mod_plsql): Accept parameters only from POST, not GET requests?

I'm working on an application that uses mod_plsql with Oracle 10G to generate web pages via PL/SQL stored procedures called directly from the web browser. I'm looking for a way to only accept parameters via POST requests, and not GET requests. Ie,…
J_J
2
votes
5 answers

How to retrieve XML into Oracle PL/SQL via an HTTP Post transaction?

I'm trying to implement the "blog this" function from Flickr using the BloggerAPI to my pl/sql based CMS. When Flickr sends me the posting transaction, the HTTP transaction looks like this: POST /pls/website/!pkg.procAPI HTTP/1.1 Host:…
MojoMark
  • 41
  • 1
  • 1
  • 8
2
votes
2 answers

Oracle HTTP Server htdocs

The trouble is, while PL/SQL procedures do generate HTML, I cannot make image folder work. That is, when I try to insert an IMG tag, it shows that it can't find that file in /xxx/img folder. I tried to redefine DocumentRoot in httpd.conf - it works…
Lachrimae
  • 51
  • 9
1
vote
1 answer

Migrating PL/SQL Web Toolkit web app from Apache/mod_plsql to Tomcat/ORDS causes issues with logging out of web app

My PL/SQL Web Toolkit application is having issues logging out. The Apache/mod_plsql configuration had a "logmeoff" function that I could use to log out when using Apache HTTP. But now that I migrated to Tomcat/ORDS, the "logmeoff" function does…
tale852150
  • 1,618
  • 3
  • 17
  • 23
1
vote
1 answer

Distinguish between Oracle mod_plsql and ORDS in frontend

I would need to distinguish in my frontend what kind of Oracle backend (mod_plsql or ords) is running and cannot seem to find a reliable way to do so. Any ideas would be most appreciated.
doberkofler
  • 9,511
  • 18
  • 74
  • 126
1
vote
1 answer

ORDS defaults.xml vs conf/.xml File Upload schema.doc_upload_table

When trying to get File Upload to work, I added schema.doc_upload_table to both defaults.xml and conf/.xml. I realized later that, because we will be using this for multiple databases, we should not specify the…
Betsy
  • 11
  • 2
1
vote
0 answers

creating XML to XSD specification in oracle database

Is there a practical way that I can generate XML data in the oracle database (stored in normal relational tables not in objects) which matches a XSD specification? Its a complicated specification involving data implemented in a large number of…
Emu
  • 494
  • 6
  • 15
1
vote
2 answers

exact fetch returns more than requested number of rows in a triger execution

I am creating a trigger for auto_generating prod_id from prod_summery the given table is PROD_ID CHAR(8 BYTE) No 1 PRODUCT_TITLE VARCHAR2(30 BYTE) No 2 PRODUCT_SUMMERY VARCHAR2(150 BYTE) No 3 INTEREST_TYPE CHAR(1…
Saumya Ranjan
  • 75
  • 1
  • 3
  • 11
1
vote
1 answer

setting http response header in mod pl/sql

I have a mod pl/sql procedure with which I want to return a responce with a HTTP status code set to 404. When sending a response via htp.p the HTTP status code is I believe by default set to 200. How could this be done?
Emu
  • 494
  • 6
  • 15
1
2 3