oexec gives ORA-01460 using OCI?

I have one questin about obdra function. If I want to bind a parameter of the following type using obndra, then how do I do it?

create procedure sp_test

   (
    rc in out number,
    age in integer
)
is
begin
commit;
end;

main()
{

sword n_ret = -1;
sb2 n_ret_indp;
ub2 n_ret_len, n_ret_rcode;

...

if (obndra(&cda, (text *) ":num_ret", -1, (ub1 *) &n_ret, (sword) sizeof(sword),

    INT_TYPE, -1, &n_ret_indp, &n_ret_rcode, (ub4) 0, (ub4 *) 0, (text *) 0, -1, -1))
...

if (oexec(&cda))

I get the following error on oexec:

ORA-01460: unimplemented or unreasonable conversion requested

This happens if the rc is declare in and out. if rc is just out type, then
the error doesn't happen.

Could anyone please tell me what to do to fix it?

Thank you very much!

Arun.

Received on Wed Oct 21 1998 - 20:16:43 CDT