Home » Developer & Programmer » Precompilers, OCI & OCCI » Getting number of rows from the OCI call from c prog
Getting number of rows from the OCI call from c prog [message #275913] Tue, 23 October 2007 06:15 Go to next message
saravanan_nitt
Messages: 31
Registered: October 2007
Location: Bangalore
Member

Pls any one can guide me how to get the no. of rows
of the table using OCI calls in c program, Environment Solaris

Thanks in advance.............
Re: Getting number of rows from the OCI call from c prog [message #275955 is a reply to message #275913] Tue, 23 October 2007 08:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select count(*) from my_table
OCI allows you to execute SQL statements.
Have a look at the link on the OCI book I posted in your previous topic.

Regards
Michel
Re: Getting number of rows from the OCI call from c prog [message #276111 is a reply to message #275913] Wed, 24 October 2007 00:48 Go to previous messageGo to next message
saravanan_nitt
Messages: 31
Registered: October 2007
Location: Bangalore
Member

Thanks Michel.....
This i know michel, is there any other way without using select
statement.
Re: Getting number of rows from the OCI call from c prog [message #276124 is a reply to message #276111] Wed, 24 October 2007 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, no one I'm aware of.

Regards
Michel

[Updated on: Wed, 24 October 2007 01:24]

Report message to a moderator

Re: Getting number of rows from the OCI call from c prog [message #276177 is a reply to message #276124] Wed, 24 October 2007 05:00 Go to previous message
saravanan_nitt
Messages: 31
Registered: October 2007
Location: Bangalore
Member

Thanks........a lot
Previous Topic: oci call libraries
Next Topic: Error in Pro*c compilation
Goto Forum:
  


Current Time: Thu Mar 28 12:49:27 CDT 2024