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!
how can i get ARM Cortex-M4/RTX OS support early access binary for STM32F4DISCOVERY BOARD. I have to use java me embedded 8 early access for developing my embedded applications.
Horrible. All of it.
Using an outdated Web Toolkit API.
Not using bind variables, leaving open a giant security hole.
And using the same magnificent reasoning that made your code so horrible, and applied it to posting a PL/SQL question in a forum that EXPLICITLY states No Product Questions.
*** Moderator Note: Question now moved to the SQL and PL/SQL space. As Billy indicates, the "Community Feedback (No Product Questions)" space clearly states that you should not post product questions in there, and it is for feedback relating to the Developer Community. Please ensure you choose the correct product related space for your questions in future.
You can use owa_util.bind_variables to open a cursor for a query string with multiple binds and pass the resulting cursor to owa_util.listprint, but beware of implicit conversions, e.g.
DECLARE PROCEDURE init_owa IS l_names owa.vc_arr; l_values owa.vc_arr; BEGIN l_names (1) := 'DUMMY_NAME'; l_values (1) := 'DUMMY_VALUE'; owa.init_cgi_env ( num_params => l_names.COUNT, param_name => l_names, param_val => l_values); END init_owa; PROCEDURE dump_owa IS l_page htp.htbuf_arr; l_rows INTEGER := 99999999; BEGIN owa.get_page ( thepage => l_page, irows => l_rows); FOR i IN 1 .. l_rows LOOP dbms_output.put_line (l_page (i)); END LOOP; END dump_owa;BEGIN init_owa; DECLARE p_deptno dept.deptno%TYPE := 10; BEGIN owa_util.listprint ( p_thecursor => owa_util.bind_variables ( thequery => q'{SELECT DISTINCT job, job || ' - ' || INITCAP (job), NULL }' || q'{FROM emp WHERE deptno = TO_NUMBER (:b_deptno)}', bv1name => 'b_deptno', bv1value => TO_CHAR (p_deptno)), p_cname => 'p_cname', p_nsize => 99, p_multiple => TRUE); END; dump_owa;END;/
DECLARE
PROCEDURE init_owa
IS
l_names owa.vc_arr;
l_values owa.vc_arr;
BEGIN
l_names (1) := 'DUMMY_NAME';
l_values (1) := 'DUMMY_VALUE';
owa.init_cgi_env (
num_params => l_names.COUNT,
param_name => l_names,
param_val => l_values);
END init_owa;
PROCEDURE dump_owa
l_page htp.htbuf_arr;
l_rows INTEGER := 99999999;
owa.get_page (
thepage => l_page,
irows => l_rows);
FOR i IN 1 .. l_rows LOOP
dbms_output.put_line (l_page (i));
END LOOP;
END dump_owa;
init_owa;
p_deptno dept.deptno%TYPE := 10;
owa_util.listprint (
p_thecursor =>
owa_util.bind_variables (
thequery =>
q'{SELECT DISTINCT job, job || ' - ' || INITCAP (job), NULL }' ||
q'{FROM emp WHERE deptno = TO_NUMBER (:b_deptno)}',
bv1name => 'b_deptno',
bv1value => TO_CHAR (p_deptno)),
p_cname => 'p_cname',
p_nsize => 99,
p_multiple => TRUE);
END;
dump_owa;
/
LOL well thanks for that. Actual feedback on the issue would have been nice..But I guess thats constructive criticism....or just being a d!ck...idk...especially that early in the morning too...amazing.
-- Doing the best with what I've got
-- You really could have just suggested using owa_util.bind_variables as @padders suggested.
-- Yea I figured it was the wrong area to post in. I did search around for the correct spot but the site is a little tough to navigate ( I don't spend my entire day on here )
But thanks for that..It did make me laugh
Sorry about that
Thanks for the help. I'll take a look and dissect. This should work, especially utilizing ow_util.bind_variables function.
Thanks a lot