Pro*c and dynamic sql
From: Kevin Hunt <khhis_at_triplecrownsvc.com>
Date: Mon, 15 Jan 2001 20:57:54 GMT
Message-ID: <lvJ86.802$eS2.189930_at_paloalto-snr1.gtei.net>
Date: Mon, 15 Jan 2001 20:57:54 GMT
Message-ID: <lvJ86.802$eS2.189930_at_paloalto-snr1.gtei.net>
[Quoted] I'm used to informix ESQLC where you can declare a sql statment using ? [Quoted] instead of host variable.
EX: prepare x as "select count(*) from location where location = ?"
EXEC SQL X using hostvariable;
Is there anyway to do this with oracle. It looks like from the documentation that you have to put the host variable in the prepare? Received on Mon Jan 15 2001 - 21:57:54 CET