Skip to content

ROracle and select query empty

4 messages · Mathieu Drapeau, David Hinds

Original
Mathieu Drapeau
# 
I am using Linux Oracle Client 9i and I am running my R scripts on a Linux box.
I logged on our Oracle administration interface and the queries that I launched were executed and returned many lines directly to my Linux box.
It looks that the problem is with the fetch method.

Thank you very much,
Mathieu
/> >/ I just installed ROracle and RDBI. The connection to the database seems 
/> >/ to work also. My problem is when I am selection rows that really exist 
/> >/ in the database, it is returning nothing. Where should I look to see 
/> >/ what could be my problem?
/>
David Hinds
#
Mathieu Drapeau <mathieu.drapeau at mcgill.ca> wrote:

            

      
      
      
    

        
Does /usr/include/sqlca.h exist?  This is a Postgres file.  My hazy
memory is that this conflicts with an Oracle header; and that if
ROracle sees this one at compile time, you get empty query results.

Try renaming this file to something else, then rebuild ROracle.

-- Dave

  
  


  


      

    

    

      
      

        


  

        

      Mathieu Drapeau
    

    

      
      #
    

  


  

      
Thanks!!!
It is working now.

Mathieu

        
dhinds at sonic.net wrote:

        

            

      
      
      
    

        

      
      
    

  
  


  


      

    

    

      
      

        


  

        

      David Hinds
    

    

      
      #
    

  


  

      
Mathieu Drapeau <mathieu.drapeau at mcgill.ca> wrote:

            

      
      
      
    

        
I'll look into whether ROracle can be tweaked to prevent this problem.

-- Dave