This content has been marked as final. Show 5 replies
please note that this can have two reasons:
1. insufficient space inside Pro*C when SQL is stored in a string - for exampl when using cursors etc
2. as far as I know SQL is limited to 1000 characters.
To check whats going on when hitting
(1.) --> Try to execute same statement using PLSQL or SQL*Plus
(2.) --> use "slter session set sql_trace=true" in Pro*C code before executing problematic code and copy the probably truncated statement from udump or trace directory to an editor and check lengh.
As workaround creating views maybe a good idea to reduce query