Bui Chi,
It sounds like VFP's OBC driver will not allow direct access to stored
prodecures. Try adding that procedure to the default value for a field and then using ADO to append a new record to the table. See if the record causes an errror and even more importantly does the field get the default value from the procedure.