I am trying to use CALLDBPROC on Windows and Unix and I have some problems (and doubts).
I have installed Natural 611 PL17, Entire Access 531 and Oracle 10g.
The application is using the statement standard, i.e., besides CALLDBPROC, the options: RESULT SETS and GIVING.
The CALLDBPROC requires to use a DDM to address, but what this address means? Do I need to generate the DDM from the Oracle database? I have generated the DDM manually, and it seems that it worked. I just have definied on NATPARM the DBID to access Oracle.
On CALLDBPROC statement, as I said, I am using RESULT SETS and GIVING options, but doesn’t matter the amount of the records that I access, an error -24333 occours. However, if I take out the options (Result sets and Giving) and the amount of the records is only one, the record is recoveried.
Do I using the statement correctly? Does anyone have any hint to use this statement?
I would appreciate it a lot if anyone could help me.