Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP: Getting column names with Dynamic SQL and ODBC-RDB

Re: HELP: Getting column names with Dynamic SQL and ODBC-RDB

From: David Sisk <davesisk_at_ipass.net>
Date: 1998/04/17
Message-ID: <DnPZ.3$P3.121776@news.ipass.net>#1/1

Beforehand, issue a "SELECT column_name FROM all_tables WHERE table_name='PERSON' ORDER BY position".

Regards,

Patrik Thelandersson wrote in message <6h7r9a$6i9_at_nike.volvo.se>...
>Please help me on the following:
>
>I want to get the column name of parameters used in a SQL statement, i.e
>
>INSERT INTO Person VALUES (?, ?)
>
>Is there a ODBC way to get a similar effect to
> EXEC SQL DESCRIBE :procid MARKERS INTO :sqldaMarkers;
>
>If I use SQLDescribeParam I get all information about the column except the
>name and I really do want to know the name.
>
>I want something like the example below to work with ODBC:
>
>ODBCManager mgr;
>mgr.Prepare("INSERT INTO Person VALUES (?, ?)");
>mgr.Set("CName", "Fred");
>mgr.Set("SurName", "Bloggs");
>mgr.Execute();
>
>Any help is appreciated.
>
>Best regards,
>
>Patrik Thelandersson
>
>
>
>
>
>
>
>
Received on Fri Apr 17 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US