SQLPLUS do, Pro*C don't
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 ENGLANDReceived on Wed Feb 22 1995 - 10:53:18 CET