Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

mod_plsql: /dev/wwv_flow.accept HTTP-400 Invalid name (Carl?)

617057Mar 8 2008 — edited Mar 8 2008
What 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2008
Added on Mar 8 2008
1 comment
337 views