Scope of "EXEC SQL PREPARE" Statement Name

Folks,

In dynamic SQL for C/C++, you code "EXEC SQL PREPARE stmt FROM string". The Oracle docs say that "stmt" must be unique. But, it says nothing of the scope of that uniqueness.

So, within what scope must "stmt" be unique? Is it unique within the C function, or unique within the C source file? Or what?

Thanks!
Gerald Winslow
Titan Systems Corp. Received on Fri Sep 13 2002 - 13:01:40 CDT