SQLPLUS do, Pro*C don't

From: Andrew McDermott <andrew_at_inf.rl.ac.uk>
Date: 22 Feb 1995 09:53:18 GMT
Message-ID: <3if1ie$1djd_at_unixfe.rl.ac.uk>


I am using the following on a SparcStation 20, Solaris 2.4 with Sun SparcWorks 3.x C compiler:

Pro*C: Release 1.5.10.1.0 - Production on Tue Feb 21 16:08:31 1995 SQL*Plus: Release 3.1.2.3.1 - Production on Tue Feb 21 16:12:08 1995 ORACLE7 Server Release 7.0.16.4.0 - Production

I'm writing a Pro*C interface to a program to fetch items out of an Oracle database. When I run the program I get nothing out of the database.

My next action was to make the program generate the SQL that one would type in to SQLPLUS to get back the same data. When I cut/paste this into SQLPLUS I get back what I expect.

So what the *** is going on? I'm using the same username and password in the program that I use with SQLPLUS. Does the owner of the database I'm accessing need to set something for me to read it through a program? Am I missing something obvious?

Thanks in advance,

---
Andrew McDermott,	URL: http://www.cis.rl.ac.uk/people/andrew/contact.html
Computing & Information		 Email:  andrew_at_inf.rl.ac.uk
Systems Department,		 Tel:    +44 235 445739
Rutherford Appleton Laboratory,	 FAX:    +44 235 445727 or +44 235 445831
Chilton, Didcot, OXON  OX11 0QX  ENGLAND
Received on Wed Feb 22 1995 - 10:53:18 CET

Original text of this message