Hi,
In the past I have created stored procedures in MS SQL and made them available to Report Studio by defining them as Query Subjects in Framework.
But, now I have to do this with an Oracle database. I have read something about Oracle packages and was wondering if I need them to access an Oracle stored procedure in Framework. Has anyone done both and know if I have to do anything different when accessing an Oracle SP or does anyone have instructions on how to do it? I will have parameters in the stored procedures.
TIA,
Rich FLowers
In the past I have created stored procedures in MS SQL and made them available to Report Studio by defining them as Query Subjects in Framework.
But, now I have to do this with an Oracle database. I have read something about Oracle packages and was wondering if I need them to access an Oracle stored procedure in Framework. Has anyone done both and know if I have to do anything different when accessing an Oracle SP or does anyone have instructions on how to do it? I will have parameters in the stored procedures.
TIA,
Rich FLowers