|
#2
longliveking2007-04-17 19:39
|
EXEC SQL CREATE GLOBAL TEMPORARY TABLE temp1 AS
SELECT split_id,routeflag,datarouteid
FROM plt_trssplit
WHERE trscode = :trancode ;
为什么这句话编译不通过，直接拿到数据库执行就可以过，:trancode是一个字串型，前边定义过了 oracle
错误信息：
Syntax error at line 62, column 38, file traninfo.pc:
Error at line 62, column 38 in file traninfo.pc
EXEC SQL CREATE GLOBAL TEMPORARY TABLE temp1 AS
.....................................1
PCC-S-02201, Encountered the symbol "TABLE" when expecting one of the following:
; random_terminal
Parser error at line 65, column 32, file traninfo.pc:
Error at line 65, column 32 in file traninfo.pc
WHERE trscode = :trancode ;
...............................1
PCC-S-02206, Host variables are not permitted within a DDL statement
Syntax error at line 65, column 41, file traninfo.pc:
Error at line 65, column 41 in file traninfo.pc
WHERE trscode = :trancode ;
........................................1
PCC-S-02201, Encountered the symbol ";" when expecting one of the following:
table, or, random_terminal function, package, procedure,
type, trigger, view, role, constraints, transaction,
