Pro*C and cursors with dynamic names

hi

i am moving some informix-esql software into oracle-pro*c environment. i have problem with cursors:

1. informix-esql allows syntax like this: exec sql declare :host_variable cursor for .... i have found in pro*c manuals that cursor name must be known in precompile time. is there a possibility to do it other way? i tried 'execute' with 'declare' 'prepare'-d and got an error :( i've heard that maybe OCI interface will help me. is it true? or the only way in this case is to know all possible names and write: switch (whatcursor) { case 1: exec sql declare cursor1 ... ; break case 2: exec sql declare cursor2 ... ; break .... and so on (the same with open/close/fetch)

i have also found that proc likes to dump core files usually not telling where error is (8.0.5).

greetz
butthead Received on Thu Aug 23 2001 - 14:08:31 CEST