Do Stored Query and the older SQL query return the same content?
Not at the moment. This season the Public Registy implements 3 Affinity Domains: • Portals that have the form portals/repository (or query or registry at the end) reference the content from last year (and earlier) • Portals that have the form portals/yr3a/repository (or query or registry or storedquery at the end) reference year 3 metadata and uses a different version of the metadata validator that validates against the new rules. • Portals that have the form portals/yr3b/repository (or query or registry or storedquery at the end) reference year 3 metadata and will be used exclusively for BPPC testing which requires slightly different validation rules. The Provide and Register, Register, and Stored Query transactions are implemented to hide the mechanisms used to separate the metadata. Unfortunately, the SQL query portal does not yet distinguish metadata assigned to different Affinity Domains. This is not intentional, just a work in progress. For now, metadata returned from an SQL quer
Related Questions
- Does Warehouse Builder have a published metadata model with SQL based query capability and/or an Application Program Interface (API)?
- Does the Migration Workbench support the conversion of T/SQL stored procedures that return multiple result sets?
- Can I use SQLJ to return PL/SQL arrays from stored procedures?
