Pro*C对inner join的支持情况

最新推荐文章于 2022-02-23 15:02:25 发布

原创最新推荐文章于 2022-02-23 15:02:25 发布 · 1.5k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#join #c #sql #query

本文解答了在使用 Pro*C 进行编程时遇到的 INNER JOIN 语法错误问题，并提供了通过动态 SQL 或升级到 11g 版本及使用 common_parser 选项来解决该问题的方法。

整理自：http://forums.oracle.com/forums/thread.jspa?threadID=664180&tstart=0

问：Is it possible to use INNER JOIN's with Pro*C? I'm currently getting this error:
INNER JOIN t_diagnosis b ON a.sak_diag = b.sak_diag
....1
PCC-S-02201, Encountered the symbol "INNER" when expecting one of the following:
; , for, union, connect, group, having, intersect, minus,
order, start, where, with,
The query runs fine via SQL Developer. My version of Pro*C is Pro*C/C++: Release 10.2.0.3.0.
Thanks,
Matthew

答：

Unfortunately the Pro*C precompiler does not understand "new" syntax/keywords... this falls into the same category as using analytics discussed here:
http://forums.oracle.com/forums/thread.jspa?threadID=664180&tstart=0
You would need to use dynamic sql as described in the programmer's guide to do this.

Support for all the ANSI 99 sql syntax (including joins) has been added in 11g w ith the new precompiler option common_parser. You can precompile your proc program containig join sqls as follows:
proc common_parser=yes proc_file.pc
For release 10.2 and earlier you would to workaround by using dynamic sqls as Mark suggested.