Eric,

> I have domains defined and used in my script to create the domains and

tables in a FB 1.5.2 database. This works fine.

>
> My stored procedure scripts are added in a subsequent script and, when

referencing the domain names in the SP parameter lists, I get an error. Why
aren't the existing database domain names recognized in the second script
that adds the stored procedures?

>
> How can I resolve this problem and keep the two scripts
> separate?

You cannot use domains in stored procedures.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com