Pro*COBOL, blobs and EXEC SQL ALLOCATE
Hi,
I am working with Oracle Database 11g2, Microfocus Server Express 5.1 and Fujitsu's openUTM 6.0 on AIX 6.1.
I am trying to read and write blobs using embedded sql and i am facing the following problem: I have several XA database connections and I am using EXEC SQL DECLARE mydb DATABASE. To work with blobs I have to allocate a lob locator using EXEC SQL ALLOCATE :mylocator. Since I am working with multiple database connections, i expected to be able to write EXEC SQL AT mydb ALLOCATE :mylocator, but this is not possible with Pro*COBOL (I have only german error messages but the precompiler says that the AT clause is not allowed here). If I omit the AT clause, I get an error during program execution, because then oracles tries to use the default connection which I don't have (and I don't want to have). I checked the manuals and it is actually not allowed to use "AT" with "ALLOCATE" - although it is possible with Pro*C/C++!.
I am working with Oracle Database 11g2, Microfocus Server Express 5.1 and Fujitsu's openUTM 6.0 on AIX 6.1.
I am trying to read and write blobs using embedded sql and i am facing the following problem: I have several XA database connections and I am using EXEC SQL DECLARE mydb DATABASE. To work with blobs I have to allocate a lob locator using EXEC SQL ALLOCATE :mylocator. Since I am working with multiple database connections, i expected to be able to write EXEC SQL AT mydb ALLOCATE :mylocator, but this is not possible with Pro*COBOL (I have only german error messages but the precompiler says that the AT clause is not allowed here). If I omit the AT clause, I get an error during program execution, because then oracles tries to use the default connection which I don't have (and I don't want to have). I checked the manuals and it is actually not allowed to use "AT" with "ALLOCATE" - although it is possible with Pro*C/C++!.
0