Using APEX 5.1.3 with universal theme.
In my PLSQL procedure I want to populate two apex page items through a SQL query, something like below
procedure test is
begin
select id, name, phone into :P100_ID, :P100_NAME, :P100_PHONE from emp e where e.join_year = v('P100_JOIN_YEAR');
end;
I am not sure if it's the syntax that is the issue or something else.
Getting error PLS-00049: bad bind variable 'P100_ID'
bad bind variable 'P100_NAME'
bad bind variable 'P100_PHONE'
Please advise.