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
1
vote
1 answer

ORA-01460 with mod_owa and OwaDocTable

I'm playing with Doug McMahon's Apache PL/SQL Gateway Module (https://oss.oracle.com/projects/mod_owa/dist/documentation/modowa.htm) in a test environment. I'm getting the error below while trying to upload a binary file using the OwaDocTable…
Cristian Veronesi
  • 300
  • 1
  • 3
  • 15
1
vote
1 answer

Oracle authentication not working?

I implemented a LogOut button which logouts user from webpage. Server is Oracle HTTP server. When clicked on LogOut it executes below procedure PROCEDURE log_me_off IS BEGIN -- Open the HTTP header owa_util.mime_header('text/html', FALSE,…
Puneet Kushwah
  • 1,495
  • 2
  • 17
  • 35
1
vote
1 answer

Porting application which uses Oracle mod_plsql to PostgreSQL

I need to port an application that uses Oracle mod_plsql to PostgreSQL. Currently database procedures are called over HTTP with the use of Apache + mod_plsql. The procedures are easily ported to PostgreSQL, but I can not find a replacement for the…
sposnjak
  • 1,491
  • 2
  • 15
  • 25
0
votes
3 answers

Can't get time zone information when using mod_plsql?

I have written a function to convert a date into a Unix time stamp. The function is written to work no matter what the current DST status is (e.g. EST or EDT). This is the function: function unix_time_from_date(in_date in date) return number as ut…
James Sumners
  • 14,485
  • 10
  • 59
  • 77
0
votes
0 answers

How to receive/process an uploaded file in PL/SQL

I'm tasked with modding a legacy web app to allow internal users to submit a csv file to be processed into several different tables in our Oracle 12.1 database. This web app's HTML content is almost entirely generated in PL/SQL (htp.p() calls). …
DaveKub
  • 983
  • 2
  • 19
  • 30
0
votes
1 answer

The "mod_owa" module is encountering an error: "Character string buffer too small ORA-06512: at 'SYS.HTP'."

In our application, currently in mode_plsql, our website is working fine. However, during the migration to AWS, we are using mod_owa on Apache HTTP server. Unfortunately, we are encountering the following error: "-6502 ORA-06502: PL/SQL: numeric or…
Priya D
  • 21
  • 1
  • 5
0
votes
1 answer

Apex insert row from form using a ODBC driver with PL/SQL

I’m currently using Apex 20.4 and tries to insert a row based on variables from another page (Wizard) Since I’m using a Snowflake ODBC I cannot just use the standard DML submit action. The query I’ve made, note that the part @snowflakecomputing is…
Peter H
  • 3
  • 1
0
votes
1 answer

How use parameters with same name in html forms pl/sql

PL/SQL DEVELOPER<------->version:10.0.5.1710 When we use owa_util.choose_date three select tag with the same name are generated.... htp.formopen(curl => 'package.procedure_prube'); owa_util.choose_date(p_name => 'date'); htp.formsubmit(cvalue =>…
Ignorant Necromancer
  • 29
  • 5
0
votes
0 answers

Oracle REST Parameter Collection

I have some Oracle databases that are exchanging HTTP calls, my central database in on 11g and using mod_plsql for GET and POST call. I want to upgrade may database and start using ORDS without replacing my current code but having some issues when…
Eilon Bootel
  • 21
  • 1
0
votes
1 answer

Using HTP.P in ATP oracle database

I've just started checking out the ATP database in oracles cloud. I have an old pl/sql proc that I want to put on the ATP database. Happily the procedure with calls to htp.p compiled with no errors...but how do I find the URL to use to get to my…
Emu
  • 494
  • 6
  • 15
0
votes
2 answers

difficulties creating a pl/sql procedure

trying to create a procedure but i keep getting an error. here is the code create or replace procedure HK.PURGE_LAN_DOTS AS batchsize number := 15000; deleteline timestamp := current_timestamp - 365; counter number := 0; BEGIN loop DELETE…
Viimal
  • 1
0
votes
2 answers

ORDS FILE UPLOAD NON-APEX MOD_PLSQL APPLICATION

We are in the process of upgrading a mod_plsql application to ORDS 3. I found some information under: File uploads in a non-Apex PL/SQL application migrated to ORDS. In this, Kris Rice states, "Important question. Do you have apex in this db at…
Betsy
  • 11
  • 2
0
votes
1 answer

Retrieving header values in PL/SQL HTP packages

We have a website running on mod plsql gateway model . The procedure will be invoked from UTL and module PL/SQL executes the HTP procedure to generate the HTML page. Now we are integration this page with siteminder so that we could integrate with…
Senthil
  • 79
  • 1
  • 11
0
votes
0 answers

update table data from HTML form in PLSQL

I'm trying to update user input field on click of a button in html form. so far my html form should call another procedure inside my package on click of the 'Update ID' button.However, i'm just receiving system error and no data is exactly being…
A. Rahman
  • 71
  • 5
0
votes
1 answer

Error when execuuting Before Insert Trigger

I have an Oracle, apex application with a MasterDetail Form. I need to do a BeforeInsert Trigger for the details part of the form. I need to populate the fields for the BEFOREINSERT_CHARGES with the data from another table (AHAR_PARTSLABOR) This is…
Amanda Lopez Rodriguez
  • 1
1
2
3