Re: OCI question: any special ways to create tables?

edmondkkmo_at_hotmail.com (Eddie) wrote in message news:<b4beedd0.0211241022.18bb4e12_at_posting.google.com>...
> 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

Ehh,

Have you tried to insert som rows in your table?

Odd M Received on Mon Nov 25 2002 - 20:21:02 CET