Re: sql from within c program

From: Chuck Dillon (cdillon_at_nimblegen.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 13:28:45 -0500

n wrote:
> Hello again:
>
>
>
> Is there a way to embed sqlplus statements within a c program.
>
> <snip>
>
> is there a certain header I need to make c recognize sqlplus cmd's like a
> sql.h
>
>

I'm assuming we're talking about Oracle given the sqlplus reference.
Oracle has a API called Pro*C (they also have a version for FORTRAN and
another for Java) which is a precompiler to C that expands embedded SQL
into C code. I believe there are similar generic technologies but I
don't know of any off-hand.

There are a number of other APIs that can be used to do SQL and RDB
interfacing from C code... ODBC is the vendor neutral API. Oracle
also offers OCI and OO4O (on Winders). Other RDB vendors have their
own flavors I'm sure.

If you are talking about Oracle look at:
http://otn.oracle.com/pls/tahiti/tahiti.show_toc?partno=a76942&remark=drilldown&word=precompiler

or otn.oracle.com in general. BTW, Oracle provides these client side
development tools at no charge. You just need license to run the clients.

-- ced 

-- 
Chuck Dillon
Senior Software Engineer
NimbleGen Systems Inc.

Relevant Pages

  • Re: SQLPLUS driver
    ... Sql*plus is NOT using odbc. ... To connect to a database using sqlplus you need a full client (all ... Eventually sqlplus uses OCI (Oracle Call Interface), ...
    (comp.databases.oracle.server)
  • SQL Server 2005 and Oracle Instant Client 10.2.0.3
    ... Having some problems with the Oracle Instant Client 10.2.0.3 and SQL Server ... "Oracle client and networking components were not found. ... I can connect to the Oracle server with SQLPlus using the "SQLPLus ...
    (microsoft.public.sqlserver.connect)
  • Re: How to insert file from client side to blob via SqlPlus ?
    ... what is the simplest way of inserting a file from a client to a blob column ... using SqlPlus? ... One of possibilities on the recent oracle version which don't involve coding in third party language could be builtin XMLDB - file can be transferred into repository by means of wide used protocols - webdav or ftp. ...
    (comp.databases.oracle.server)
  • Re: sql from within c program
    ... >> Is there a way to embed sqlplus statements within a c program. ... > I'm assuming we're talking about Oracle given the sqlplus reference. ... ODBC is the vendor neutral API. ... Oracle provides these client side ...
    (comp.unix.programmer)
  • RE: Breakable
    ... One of the problems with this is that sqlplus assumes that the user must ... permissions to run svrmgrl as the oracle user so they can ... at least pose some other security risks. ... the database rather than the client also suggests to me that Oracle's ...
    (Bugtraq)
Loading