Oracle Stored Procedure Not appearing in data source

[farside11]

Hi,

I am using CR10 with oracle 9i and native driver connection. I have created a stored procedure within a package ie consisting of the package & package body - all as per the BO white paper. However, when selecting SP for data source it does not show up and yes the SP option is ticked under file options!
So help what has gone wrong or does the white paper lie?

Thanks for any tips.

Cheers

 

[Turkbear]

Hi, Are you sure the user you are logged in as has permissions in Oracle to run the SP?

Also, test the SP in SqlPlus to be sure it is valid..

It does, I assume, since you followed the white paper, return a REFCURSOR?

Are you looking for the SP name ( as you should) and not the package name?
In the correct schema?


They do work...






To Paraphrase:"The Help you get is proportional to the Help you give.."