> Hello,
>
> I need to write a quite specific utility where I need to compare 2 sps
> belonging to 2 databases and need you advice and ideas.
>
> I have considered two possible options :
>
> 1) grab the stored procedure text, replace all tab, multiple spaces
> and line feeds by a single space for both SP source code and then do a
> simple compare
>
> 2) grab the BLR representation and compare both.
>
> I assume that the BLR would be the same regardless of spaces, tab,
> extra lines and that it would be probably be the safest comparison method.
>
> Any comments or opinions will be very welcomed
>
> Didier

there are db compare utilities which use a reference and target db, they
compare and result in an alter statement for the procedure.
Is this no good for your purpose?
Alan