How do I edit/view a Stored Procedure???

[BeeBear]

Hi,

Using Crystal v10, on an Oracle ODBC Database.

First, I have NO experience in building or using stored procedures, so please keep your answer as simple as poss for me.

We have report that runs off a stored procedure instead of a Table. I have no data/documentation on how the person who built this did it (he is no longer contactable), but I need to find out where the source data to create the SP came from, and how it works, as we need to replicate something similar in a new report.

When you run the report, it automatically asks for 3 parameters (which we don't know), before giving any data. A colleague is trying to track down the required parameter values. I'm presuming that those 3 parameters are what builds the stored procedure.

Any help or pointers would be greatly appreciated.

 

[kskid]

This user wants to know as well. I am using Crystal XI R2 with BOE XI R2 with Oracle 8I database.

I believe the stored procedures are maintained in Oracle but not sure how to make them accessible to Crystal Reports.

-lw

 

[dgillz]

click on file, options, database tab to make SPs available to crystal.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[cjlarue]

who is responsible for maintaining your database? I would think that your DBA (database admin) would be of some help. if not then start by reviewing the code (sql)of the stored procedure. This will tell you what tables are being accessed and what the parameters are compared to. This should also give you an idea of what you will need to do to create your procedure for the new report.
Regards

 

[BeeBear]

Hi,

Thanks for your responses.

I'm not sure if I made myself clear. The SP is currently being used in crystal to run the report in question. I needed to see what sql code was behind the SP so I could figure out what was being used to create the SP.

Unfortunately this database was never fully documented and I think I'm the nearest thing we have to a dba (sad aint it!). However we have been in touch with the original programmer who wrote this and I've now got the sql behind the SP.

Once I've reviewed this, I'll post another Q if I need to.

Thanks

 

[kskid]

It you havea tool like TOAD by Quest Software, then you will be able to see the stored procedure in its entirety.