mod_plsql: /dev/wwv_flow.accept HTTP-400 Invalid name (Carl?)
617057Mar 8 2008 — edited Mar 8 2008What does this error mean? I'm getting it when I use the textfield_autofilter.js with the following on demand package, but the issue only comes up in Safari. The error happens once I submit the page after filling out a field that has been registered with the textfield_autofilter.
mod_plsql: /dev/wwv_flow.accept HTTP-400 Invalid name
DECLARE
TYPE curtyp IS REF CURSOR;
v_row VARCHAR2 (4000);
rec curtyp;
BEGIN
:tf_sl_search := REPLACE (:tf_sl_search, '&', '&');
:tf_sl_search := REPLACE (:tf_sl_search, '<', '<');
:tf_sl_search := REPLACE (:tf_sl_search, '>', '>');
:tf_sl_search := REPLACE (:tf_sl_search, '"', '"');
OWA_UTIL.mime_header ('text/xml', FALSE);
HTP.p ('Cache-Control: no-cache');
HTP.p ('Pragma: no-cache');
OWA_UTIL.http_header_close;
HTP.prn ('<rowset>');
-- Add some code to prevent SQL injection attacks
-- on :TF_SL_TABLE and TF_SL_COLUMN here ...
OPEN rec FOR 'SELECT DISTINCT '
|| :tf_sl_column
|| ' '
|| 'FROM '
|| :tf_sl_table
|| ' '
|| 'WHERE UPPER('
|| :tf_sl_column
|| ') like UPPER(''%'' || :1)||''%'' '
|| ' AND ROWNUM < 100 '
|| -- change this to the maximum of rows you want to return
'ORDER BY '
|| :tf_sl_column USING :tf_sl_search;
LOOP
FETCH rec
INTO v_row;
EXIT WHEN rec%NOTFOUND;
HTP.prn ('<row>' || HTF.escape_sc (v_row) || '</row>');
END LOOP;
HTP.prn ('</rowset>');
END;