At 05:47 PM 11/08/2003 +0700, you wrote:

>I have create stored procedure (in FB 1.5 RC5), but i have a problem when i
> insert into two table (table_1 and table_2) in one procedure
> because table_2 has field that dependent on table_1 (primary key field)
>how to use commit after first insert ?

You can't commit from inside a stored procedure.
Post the definition of the SP here and we'll help you to fix it.

heLen