Gurus,
I am doing something wrong but I just can't figure out what.
On my page I have 2 processes:
1. Fetch Row from VAR Automated Row Fetch
2. Load Temp Table PL/SQL anonymous block (which I wrote, see below):
BEGIN
EXECUTE IMMEDIATE 'TRUNCATE TABLE foobar_1';
EXECUTE IMMEDIATE 'insert into foobar_1 select * from (
SELECT q.oracle_quarter, p.probability, SUM(pi.lic_rev_net_oracle) rev
FROM pipeline pi, oracle_quarter_lookup q, probability_lookup p
WHERE q.oracle_quarter_id = pi.oracle_quarter_id
AND p.probability_id = pi.probability_id
AND pi.probability_id NOT IN (100, 0)
AND pi.var_id = :P11_ID
GROUP BY q.oracle_quarter, p.probability)';
END;
When I run the page I get the following error message:
ORA-01008: not all variables bound
And obviously if I hardcode the pi.var_id to an id that exists the wuery works perfectly fine so the query seems to be correct, it is just the :P11_ID bind var that seems to be null or something?
And I just can't figure out what the problem is. I have checked the spelling of the var P11_ID, and the very same var is used in other queries on the page and they work perfectly fine.
I am on APEX 3.0.1.
Any ideas are super welcome
Andy
Message was edited by:
A Tael