Crystal report: Not supported Details: cannot obtain error message from server

Posted on 2006-05-10
Last Modified: 2011-08-25
Created a store prcedure in Oracle.

Created a new crystal report.

Created a new command. Try to select the procedure into the command. Get this error message:

Nnot supported cannot obtain error message from server.

Question by:HKBoyz
    LVL 42

    Expert Comment

    That could mean just about anything.  Why are you trying to use the command to connect to the stored procedure instead of just hitting it normally?  It's quite possible that you have a syntax error in your call to the procedure.

    Also, does your Oracle SP return a ref cursor as it's first IN OUT parameter?

    Author Comment

    we are trying to insert data into a temp table in the SP, and that may be the reason I am getting that error since Crystal Command doesn't allow any DML activities.

    IS there any other work around?
    LVL 42

    Accepted Solution

    I'd say that's a possibility.

    I've successfully called Oracle SP's that in turn call other SP's to do a wide array of processing and have never had any problems.  In every case though, I just connect to the SP through the Create Report Wizard instead of via a Crystal Command.  I can't say for certain that'll make a difference but I'd give it a shot.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now