Re: Using hints in Pro*C
Date: Thu, 29 Oct 1998 15:10:21 +0100
Message-ID: <719t1f$vc$1_at_minus.oleane.net>
Have you tried to place your whole SQL statement with hint comments within a "EXEC SQL BEGIN;" / "EXEC SQL END;" section, without placing any EXEC SQL prefix before your query ?
L.B.Vanting_at_t-online.de a écrit dans le message <70iid2$fuj$1_at_news00.btx.dtag.de>...
>I'm trying to use hints in a Pro*C cursor but when I examine the sql trace
>file, it seems that the hint (probably seen as a comment) is removed by
>Pro*C.
>
>Has anyone experienced this?
>Any input would be appreciated.
>
>I'm thinking of some work-arounds, but I'm not keen on rewriting the whole
>Pro*C program, i.e. in OCI.
>
>Thanks in advance!
>
>Regards
>Lars Bo Vanting, COREBIT TPI ATG, Switzerland
>LarsBoV_at_corebit.dk
>
>
Received on Thu Oct 29 1998 - 15:10:21 CET