cursors in embedded sql in c
604067Nov 9 2007 — edited Nov 10 2007Hi, i have this cursor as follows in sql/pl:
cursor partsc (s spj.s#%type)
is select * from Parts p where exists (select * from SPJ j where p.p#=j.p# and j.s#=s);
Im trying to translate this into c code for it to work the same
I got a non paramterized one to work but dont know how to use this one.
Thanks
Message was edited by:
user601064