sql - OCI : ERROR while executing CREATE and DROP table

Question

我正在使用 C API 从 Oracle 数据库创建和删除表。代码片段是

OCIStmt *stmt;
rc = OCIHandleAlloc(ora_env, (dvoid **)&stmt, OCI_HTYPE_STMT, 0, 0);

char *query = "DROP TABLE idmap_id;";
rc = OCIStmtPrepare(stmt, errhp, (OraText*)query, strlen(query), OCI_NTV_SYNTAX, OCI_DEFAULT);
rc = OCIStmtExecute(svchp, stmt, errhp, 1, 0, NULL, NULL, OCI_DEFAULT);

当我运行此 DROP TABLE 查询时，出现以下错误

OCIStmtExecute() ORA-00933: SQL command not properly ended

当我用这样的 CREATE TABLE 替换查询时

char *query = "CREATE TABLE idmap_id (id varchar2(32 CHAR) NOT NULL, CONSTRAINT idmap_id_pk PRIMARY KEY (id));";

我收到错误

OCIStmtExecute() ORA-00922: missing or invalid option

有人可以帮我吗？

Answer 1

删除分号。

(我猜 Oracle 期望在它之后还有另一个 SQL 语句。)