Stucked while preparing an sql request pro*c

Asked Mar 15 '18 at 14:50

Active Dec 24 '18 at 13:20

Viewed 109 times

I have a binary that I generated from a program written in C language and that stucks in this line of code:

EXEC SQL PREPARE x FROM: y;

with 'y' is a simple selection request:

select count(distinct id_appli) FROM APPLICATION WHERE id_appli = '2' ;

could you tell me the cause of such a problem ?

PS : I'm working on AIX Sometimes I got a core file, when I used gdb command I got this result :

core: AIX core file fulldump 32-bit,

Program terminated with signal 11, Segmentation fault.
#0  0xd482acac in skgesig_sigactionHandler ()
   from /produits/oracle/db/11.2.0.2/lib32/libclntsh.so
(gdb) where
#0  0xd482acac in skgesig_sigactionHandler ()
   from /produits/oracle/db/11.2.0.2/lib32/libclntsh.so
#1  <signal handler called>

edited Dec 24 '18 at 13:20

phuclv

37,963
15
156
475

asked Mar 15 '18 at 14:50

Alma

Which database/embedded language? – Paul Ogilvie Mar 15 '18 at 14:52
Any error message you are receiving? – Eray Balkanli Mar 15 '18 at 14:54
Oracle 11.2.0.2/C language – Alma Mar 15 '18 at 14:54
@ErayBalkanli : No I don't get any error message – Alma Mar 15 '18 at 14:54
I added some details in my request message above – Alma Mar 15 '18 at 14:58
Need to see the actual code where you declare and assign `y` and execute the prepare statement. – John Bode Mar 15 '18 at 15:28
Run the program in gdb debugger to find out more. Also it would be useful to disable Oracle's signal-handlers, see the question: https://stackoverflow.com/questions/17124881/oracle-proc-oci-install-handlers-for-sigsegv-sigabrt-and-friends-why-and-how – Lorinczy Zsigmond Mar 15 '18 at 19:30
I think you have to SELECT INTO some host variable previously DECLAREd. – ulix Mar 16 '18 at 07:06

Stucked while preparing an sql request pro*c

0 Answers0