Hi all,
We have migrated our application from PB8 to PB10 and oracle client from 8.4 to 9.2i.
What we observed that the procedures which are declared using declare procedure syntax behave inconsistantly in PB10.
Some of them work fine, some of them fails but all of them work fine with PB8.
When we declared the procedure in SQLCA as RPCFUNC they definately work.
Can anyone explain me pros and cons in declaring procedure using declare procedures and declaring as RPCFUNC ?
Can any one put light on why it is working fine when it is declared as RPCFUNC ?
Which method is more reliable ?
Thanking in advance,
Abhijit.
We have migrated our application from PB8 to PB10 and oracle client from 8.4 to 9.2i.
What we observed that the procedures which are declared using declare procedure syntax behave inconsistantly in PB10.
Some of them work fine, some of them fails but all of them work fine with PB8.
When we declared the procedure in SQLCA as RPCFUNC they definately work.
Can anyone explain me pros and cons in declaring procedure using declare procedures and declaring as RPCFUNC ?
Can any one put light on why it is working fine when it is declared as RPCFUNC ?
Which method is more reliable ?
Thanking in advance,
Abhijit.