Hello,

The primary key for the row gets incremented to the next max value using a trigger at the time of inserting a new row.
When i immediately try to get the value of this primary key, for the new row that was inserted, using a select statement: "select max(recID) from rec", a error is thrown saying "FROM keyword where was expected".
The session seems to be using prepared statement, where i wld like to use a statement to get the value of the primary key.
Is there another way out to find the value of this primary key after a new insert.

Thanks in advance.


Regards
sreedhar