var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select into
Having a bit of trouble selecting into: -
logic := 'select 1, 2
into varA, varB'
execute immediate logic;
What am I doing wrong?
you failed to select into something. execute immediate causes Oracle to treat your work as a PL/SQL block, and you cannot select in a PL/SQL block unless you select into variables.
the kind of command you showed is generally not suitted to using the execute immediate command, but I guess it was just an example.
the execute immediate command has an INTO clause you need to read about.
logic := 'select 1,2 into :varA, :varB from tblA'
execute immediate into varA, varB;