Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NVL2 in pro cobol giving the error.

414001Oct 31 2006 — edited Nov 4 2006

For some reason we are getting an compiler error when we use NVL2 function in embedded sql statement in a pro-cobol module. Here is the output from the compiler. Do we have to add any options to recognize the new functions/keywords?

procob iname=vas107h2.pco include=/oracle/home/product/9.2.0/precomp/public ireclen=132 oreclen=132 sqlcheck=full ltype=none
" PICX=VARCHAR2 include=/jsbatch/vista/dev/cobol/cpy

Pro*COBOL: Release 9.2.0.7.0 - Production on Tue Oct 31 13:49:35 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

System default option values taken from: /oracle/home/product/9.2.0/precomp/admin/pcbcfg.cfg

Error at line 595, column 12 in file vas107h2.pco
EXEC SQL DECLARE DRIVER CURSOR FOR
...........1
PCB-S-00576, PLS-201: identifier 'NVL2' must be declared
Error at line 595, column 12 in file vas107h2.pco
EXEC SQL DECLARE DRIVER CURSOR FOR
...........1
PCB-S-00576, PLS-0: SQL Statement ignored
*** Error code 1
make: Fatal error: Command failed for target `vas107h2'

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2006

Added on Oct 31 2006

#general-database-discussions

5 comments

2,193 views