Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2006
    Posts
    31

    Unanswered: OCCI - How To Tutorial

    Hello everyone,

    sorry this is a completely 'noob' question... i guess it makes sense for my first post.

    I am trying to create a c++ application, which uses oracle to store the data. I have been to oracle and found the OCCI information, which tbh i find suprisingly confusing.

    All i would like to know is how to use c++ express to access oracle 10g database, using the OCCI. Once i have a connection, i think i will be able to work out the rest.

    if ther eis any help you can give me or direct me to i would be very greatful

    scott

  2. #2
    Join Date
    Aug 2006
    Posts
    31

    Talking

    £10 for first person to help!...

    the award has gone to 'rbaraer'
    Last edited by Scott_Higgins; 08-25-06 at 06:28.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    You can have a look at this thread in which I posted a simple OCCI program that sends an array of data to a stored procedure.

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  5. #5
    Join Date
    Aug 2006
    Posts
    31
    thanx rbaraer, i looked at that code and it gave me a clearer idea...

    i still dont understand how c++ knows how to use

    'using namespace oracle:cci;'

    I use vc++ 2008, and even with #include <occi.h> at the top it throws an error saying oracle isnt a namespace.

    can u please give me a clue as i really need to know and dont find the oracle documentation very helpful?

    thanks again,

    scott

  6. #6
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    The namespace is defined in "occi.h" and is resolved thanks to :
    Code:
    #include <occi.h>
    You have to add the path to the OCCI header files in your compile command.

    What are you using : a full client or instant client ? If you are using instant client, then maybe you have not downloaded the SDK which includes the header files ? If so, follow the link corresponding to your platform here , the sdk download is at the bottom of the page.

    BTW the OCCI official page is here in case you had not found it, but I know the OCCI resources are not very helpful .

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  7. #7
    Join Date
    Aug 2006
    Posts
    31
    i have only done as i am told with programming (as, until now, i have just been a student "learning")

    so a lot of things are confusing sorry if i seem slow....

    how do i add the path to the OCCI header files in my compile command? i take it requires more than just having #include <occi.h> at the top?

    also i have downloaded the instant client.. put the folder in with my project and added it to the path under tools/options/c++ directories

    none of this works yet... what am i missing

    this may kill me lol

    thanks a lot for your help tis gr8

  8. #8
    Join Date
    Aug 2006
    Posts
    31
    i went back and created a Win32 console application.. the header files work as i would expect here....

    before i was using windows forms, under something called CLR?

    is it not possible to use windows forms with OCCI?

  9. #9
    Join Date
    Aug 2006
    Posts
    31
    seriously confused now..

  10. #10
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    I think you should first look for a good C++ tutorial since your questions are more related to C++ than to Oracle .

    There must be many such tutorials on the web.

    Then come back for serious Oracle work .

    Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •