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 wOOdy-Soft 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 sathipatla

  1. sathipatla

    ORA-00942 table or view does not exist

    One more thing is I am able to create the report based on the stored procedure if I log in as the owner. Crystal is weird sometimes.
  2. sathipatla

    ORA-00942 table or view does not exist

    Like I said before I am able to run the procedure fine from SQLPlus. This procedure is in a Package. I am able to create reports fine using procedures in other packages. We use public synonyms on the packages.
  3. sathipatla

    ORA-00942 table or view does not exist

    I am using Oracle native driver. This report is within a package. I am able to access other stored procedures contained in other packages fine. We use public synonyms for the packages.
  4. sathipatla

    ORA-00942 table or view does not exist

    I am trying to create a new report based on as Oracle stored procedure and I get the "ORA-00942 table or view does not exist" error (I am able to see the procedure in the data explorer window. When I double click on it to add it to the report it prompts me for the parameters. After 5...
  5. sathipatla

    ORA-00942 table or view does not exist

    I am trying to create a new report based on as Oracle stored procedure and I get the "ORA-00942 table or view does not exist" error (I am able to see the procedure in the data explorer window. When I double click on it to add it to the report it prompts me for the parameters. After 5...
  6. sathipatla

    How to pass a multiple value paramter to an Oracle stored procedure

    I have a stored procedure which accepts one STRING value as input parameter. Crystal prompts me for this correctly. But user can enter only ONE value. Something like Chris or Robert or Alex. The user cannot select Chris and Robert. In essence I cannot get a string something like...
  7. sathipatla

    multiple data in stored procedure parameter

    Did anyone find the solution? How can we pass a multiple value parameter to a stored procedure if one is not using any front end tool. We cannot format the parameter to a single string and passs it to the procedure as crystal doesnot allow that. Please let me know if anyone has the solution.
See more

Part and Inventory Search

Back
Top