using select statement when inserting values into table
558438Jan 26 2007 — edited Jan 28 2007Hello,
Using standard SQL i can insert into a table using a select statement e.g.:
insert into table
values
(
'1',
(select 'test' from dual)
);
I cannot seem to do this via the 'After Parameter Form' trigger for reports 6i. I get the following error: 'encountered the symbol "Select" when expecting one of the following (-+.'
Doe anybody know why this is and a possible resolution?
Thanks,
BC.