B
beginetienne
Guest
I have decided to change the stored procedure to accept a input parameter for catalog name. The stored procedure is always executed on the PRIMARY database, althought the queries inside the SP will qualify the schema with the catalog passed as input. If in_catalog.equals(""), do not prefix the query with catalog - query runs on primary DB. Otherwise, qualify all queries schema with input catalog to allows querying auxiliary DB. This allows me to run the stored procedure in any context and is an acceptable solution right now. Thanks, Etienne
Continue reading...
Continue reading...