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

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

Comment on Re^2: DBD ERROR: error possibly near <*> indicator at char Select or Download Code

Replies are listed 'Best First'.
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]