B
beginetienne
Guest
Hi, Running a stored procedure, I get **Error in Stored Procedure Execution. Couple of Facts: 1-It occurs only when multiple databases are connected. 2-The stored procedure does a select count(*) on all tables. 3-I have a DSN connection with several auxiliary databases. Stored procedure run as follows: {call catalog1.pub.sp001()} {call catalog2.pub.sp001()} ... {call catalog9.pub.sp001()} 4-All auxiliary databases (and primary) have the same stored procedure. 5-Doing a direct connection (no auxiliary dbs) and running the stored procedure works. ------- I assume the cause stored procedure fails because the catalog name is not specified in the select count() query. I feel I should not have to pass the catalog name to the SP. I will if this is the only solution. Anyone had similar issues with stored procedures and mutliple catalogs ? Any input appreciated. Thanks! Etienne
Continue reading...
Continue reading...