I 'm sorry it's my mistake in casting current_timestamp to varchar(23)
--> varchar(24)

Helen Borrie wrote:

>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
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>