Re: Getting value of serial column after insert inside stored procedure, help!

vsp@triada.triad.com (Vaishali Padhye) wrote: >Hi, >I am inserting a record in a stored procedure for a table having >a serial column, now I want to find out the value the serial >column got assigned and return it. >I know it gets assigned in sqlca.sqlerrd[1], but thats useful in >4gl or esql program, can this structure be accessed in a stored >procedure? Any pointers will be a great help. Thanks! >Vaishali Padhye >Triad Systems Corp. >#include <std_disclaimer.h> There should be no problems in returning the sqlca.sqlerrd[2] in your procedure. I have done this extensivley in 7.11. (entrican@exo.com)