I have an oracle datasource that connects tot he oracle database using credentials that I can use in SQL Developer to execute the tored procedures. However, when in SSRB I add a dataset that uses the oracle datasource and and query type: Stored Procedure, I see a bunch of stuff like 'APEX_ etc..' or ' DBMS_' but not my stored procedure. In fact, when I type it in and click on refresh fields, i get ORA-06564: object CS_PARTIES_GET does not exist ORA-06512: at "SYS.DBMS_UTILITY", line 156 ORA-06512: at line 1 ????? Thanks for any insight Terry GADOI

Hello Terry, Seems like you may are connected to the wrong Oracle database. How have you setup the data source?Olaf Helper Blog Xing

connection string points to an existing oracerl database with credentials that are unique to that database. I would think if I were pointing to a diffewrent oracle database - the credentials would not work. These credentials are unique to the database I am using.GADOI

Hi Gadoi, Since the credentials are unique to each database, then click the Test connection button and ensure you can connect this oracle database successful. And ensure you have selected correct data source if you create multiple data source when create a dataset. Here have some MSDN documents about oracle connection type which might helpful for you, please see: http://msdn.microsoft.com/en-us/library/dd220591.aspx http://msdn.microsoft.com/en-us/library/dd220525.aspx Hope this helps. Regards, Charlie Liao If you have any feedback on our support, please click here. Charlie Liao TechNet Community Support