Why does sqlca.sqlerrm.sqlerrmc sometimes cause error "sqlerrm not a member of struct sqlca_s"?

Posted on 2011-10-07
Last Modified: 2012-05-12
I have an Oracle pro*c program where for one branch when the generated c code is compiled the IBM xlc compiler now complains "sqlerrm is not a member of struct sqlca_s" when I reference sqlca.sqlerrm.sqlerrmc.  Am including  <sqlca.h> directly.   I cannot find struct sqlca_s or a relevant #define in any Oracle  9 or my application's header files.  Nothing unusual is visible in the C file.
This does not happen in another, unrelated code branch but I cannot find the difference that is causing this.
Question by:maswanson
    1 Comment

    Accepted Solution

    I found the answer.  The Oracle Tuxedo product includes a <sqlca.h> of its own and I had its -I first in the list.   Reader that header file, it appears that struct sqlca_s is (or was) the type of the all caps SQLCA global variable.

    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.

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    The goal of this video is to provide viewers with basic examples to understand how to create, access, and change arrays in the C programming language.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    761 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

    7 Experts available now in Live!

    Get 1:1 Help Now