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 -> HELP: Creating Tables with ODBC on UNIX

HELP: Creating Tables with ODBC on UNIX

From: <genson_at_sonexent.com>
Date: 1997/12/12
Message-ID: <881956532.1425408007@dejanews.com>#1/1

I am trying to create a table using ODBC in Oracle 7. I have successfully used SQLGetTypeInfo to obtain the Type_Name. After obtaining the result set, my code calls "SQLPrepare" to build the create table SQL statement. I am attempting to use parameter markers in place of the field types in the SQL statement definition. Once bound using SQLBindParamater and executed using SQLExecute, I get the following error:

[INTERSOLV] [ODBC Oracle driver][Oracle] ORA-01036: illegal variable name/number

First, am I following the proper procedure? Second, what am I doing wrong?

Thanks in advance,
Phuong

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Fri Dec 12 1997 - 00:00:00 CST

Original text of this message

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