Re: DBD ERROR: error possibly near <*> indicator at char

Replies are listed 'Best First'.
Re^2: DBD ERROR: error possibly near <*> indicator at char by shalu (Initiate) on Sep 21, 2010 at 14:34 UTC
SELECT statment runs fine as sson as I put `INSERT INTO <TABLE NAME>` it gives me error message But I see in DBI the insert statent is done `$sth = $dbh->prepare(qq{ INSERT INTO people (fullname, age) VALUES (?, ?) });` [download] Would that make any difference	[reply] [d/l] [select]
Re^3: DBD ERROR: error possibly near <*> indicator at char by runrig (Abbot) on Sep 21, 2010 at 16:07 UTC
No, DBI/DBD just passes the sql statement to the database. But from the syntax of INSERT, it looks like you are not allowed to have a specific column list to insert into if you have a subquery (maybe it depends on the Oracle or Oracle client library version?). But, I agree with the poster elsewhere in this thread that a sequence would be a much better way to get an incrementing value.	[reply]