Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hempsh

  1. hempsh

    Oracle stored procedure does not work

    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...
  2. hempsh

    Oracle stored procedure does not work

    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?
  3. hempsh

    Oracle stored procedure does not work

    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...
  4. hempsh

    Oracle stored procedure does not work

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

    Oracle stored procedure does not work

    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...
See more

Part and Inventory Search

Back
Top