PRO*COBOL and parameters of CALL's created by it

Hi all,

I have the need to know the number (and type if possible) of the parameters for the call's that are created by PRO*COBOL.

e.g.
a

    EXEC SQL CONNECT :USERNAME IDENTIFIED BY :PASSWD     END-EXEC.
will be converted to

           CALL "ORASQL8"
           MOVE 10 TO SQL-ITERS
           MOVE 36 TO SQL-OFFSET
           MOVE 0 TO SQL-OCCURS
           CALL "SQLADR" USING SQLCUD SQL-CUD
           CALL "SQLADR" USING SQLCA SQL-SQLEST
           MOVE 256 TO SQL-SQLETY
           CALL "SQLADRVC" USING
               USERNAME-LEN IN USERNAME
               USERNAME-ARR IN USERNAME
               SQL-SQHSTV(1)
           MOVE 12 TO SQL-SQHSTL(1)
           MOVE 0 TO SQL-SQHSTS(1)
           MOVE 0 TO SQL-SQINDV(1)
           MOVE 0 TO SQL-SQINDS(1)
           MOVE 0 TO SQL-SQHARM(1)
           CALL "SQLADRVC" USING
               PASSWD-LEN IN PASSWD
               PASSWD-ARR IN PASSWD
               SQL-SQHSTV(2)
           MOVE 12 TO SQL-SQHSTL(2)
           MOVE 0 TO SQL-SQHSTS(2)
           MOVE 0 TO SQL-SQINDV(2)
           MOVE 0 TO SQL-SQINDS(2)
           MOVE 0 TO SQL-SQHARM(2)
           CALL "SQLADR" USING SQL-SQHSTV(1) SQL-SQPHSV
           CALL "SQLADR" USINGSQL-SQHSTL(1) SQL-SQPHSL
           CALL "SQLADR" USING SQL-SQHSTS(1) SQL-SQPHSS
           CALL "SQLADR" USING SQL-SQINDV(1) SQL-SQPIND
           CALL "SQLADR" USING SQL-SQINDS(1) SQL-SQPINS
           CALL "SQLADR" USING SQL-SQHARM(1) SQL-SQPARM
           CALL "SQLADR" USING SQL-SQHARC(1) SQL-SQPARC
           CALL "SQLBEX" USING SQLCTX SQLEXD SQLFPN

Which gives us the following routines.
Routine	parameters (may have more than these!!)
ORASQL8	0
SQLADR	2
SQLADRVC	3
SQLBEX	3

And there are a lot more that can be created depending on the "EXEC". Is there anyone from ORACLE that can give me the requested information before I post this information in Oracle Metalink? This both for Oracle 8x and 9x

Thanks

Frederico Fonseca Received on Tue Jan 14 2003 - 13:06:47 CST