PCC-S-02201 CONNECT BY NOCYCLE PRIOR
hi
precompiling a .pc file containing this statement, throws and error
EXEC SQL DECLARE Benchmarkhist0004_C CURSOR FOR SELECT 1
FROM benchmarkhist
WHERE elem_ref_id != benchmark_id and connect_by_iscycle=1 START WITH benchmark_id = HEXTORAW(:Benchmark_id) CONNECT BY NOCYCLE PRIOR elem_ref_id = benchmark_id;
EXEC SQL OPEN Benchmarkhist0004_C;
ber@pdxenlin46 (64bit):~/xentis_orig/source/bd> proc include=../../include include=../../include include=/usr/include/linux code=cpp cpp_suffix=cpp threads=yes iname=BDBenchmarkhistBroker.pc oname=BDBenchmarkhistBroker.cpp
Pro*C/C++: Release 10.2.0.2.0 - Production on Mi Aug 10 11:59:54 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
System default option values taken from: /software/oraClient/actual/precomp/admin/pcscfg.cfg
precompiling a .pc file containing this statement, throws and error
EXEC SQL DECLARE Benchmarkhist0004_C CURSOR FOR SELECT 1
FROM benchmarkhist
WHERE elem_ref_id != benchmark_id and connect_by_iscycle=1 START WITH benchmark_id = HEXTORAW(:Benchmark_id) CONNECT BY NOCYCLE PRIOR elem_ref_id = benchmark_id;
EXEC SQL OPEN Benchmarkhist0004_C;
ber@pdxenlin46 (64bit):~/xentis_orig/source/bd> proc include=../../include include=../../include include=/usr/include/linux code=cpp cpp_suffix=cpp threads=yes iname=BDBenchmarkhistBroker.pc oname=BDBenchmarkhistBroker.cpp
Pro*C/C++: Release 10.2.0.2.0 - Production on Mi Aug 10 11:59:54 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
System default option values taken from: /software/oraClient/actual/precomp/admin/pcscfg.cfg
0