Re: Does such an animal exist?

On 2005-09-07, milkyway <d0mufasa_at_hotmail.com> wrote:
> Hello,
>
> What I am looking for sample code that does the following:
>
> A query (created in C) that uses the following definition for a table:
>
> create table foo (
> SampleInt integer NOT NULL,
> SampleString char(15) NOT NULL,
> SampleChar char NOT NULL,
> SampleTime date NOT NULL);
>
> Then, in the C code have
>
> "Select * from table foo".
>
> Then for each row selected (in the C code) print out each variable
> seen.
>
> I have head that CDEMODSA.C helps with this a little but unfortunately,
> I don't have it on my system ;-(
>
> Does such a program exist? If not, then is there one that is close to
> it - something with SELECT statements only - no INSERTs, DELETEs or
> UPDATEs. Would it be possible to get a copy of CDMEODSA.C?

I have once written kind of an OCI wrapper in c. You can find it on my homepage at
http://www.adp-gmbh.ch/ora/misc/oci/adpoci/select_table.html

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/