Search results for query: *

Lisa, thank you for the sample code and your suggestions. I found if I changed the select used to insert rows in the temporary table so that it was not based on a date field, it worked. If I converted the date in the select to a text compare by using a TO_CHAR function, it also worked. It...

Lisa, thanks for the suggestions. I have not been able to get it to work. Have you done stored procedures using a temporary table and returned results to crystal? What driver did you use? Would you be willing to share a sample?

I created a simple procedure, just to test the concept of creating a temporary table and then being able to return the records from the temp table to crystal. In reality, I would only use this in a procedure that was more complex, involving more tables and updating the data in the temp table...

Actually, I did use the CR Oracle8 v3.6 driver in case (b), not the CR Oracle8 driver as stated.

I am trying to use an oracle stored procedure in a crystal report, using Oracle 8.1.7.00 and Crystal 8.5. The code for the procedure and related objects are shown below and were created in the its1 schema. I am trying to run the report logged on as user reports. I get different results...