Hello everyone,
I am trying to write my first OCI program. I am using Oracle 8i using
XP. The problem is, when I use the pre-generated tables in sqlplus
(emp, dept), my program works fine with select/insert/fetch etc. But
when I define my own tables(student, grade, etc), even a simple select
statement like 'select name from student' won't work anymore. It
returns no data. So is there any special ways for us to define tables
for use of OCI programming? Here's my DDL for table student:
create table Student (
lst varchar2(20),
first varchar2(20),
phone char(10),
gender char,
primary key(lst, first));
Thanks.
Ed