Skip to Main Content

DevOps, CI/CD and Automation

Announcement

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!

using select statement when inserting values into table

558438Jan 26 2007 — edited Jan 28 2007
Hello,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2007
Added on Jan 26 2007
3 comments
446 views