Hello!
We have an unusual problem with DOA, but we also have a fix.
Seems that with Oracle 8.16, if you use a local function call in the select statement for a ref cursor, it causes a crash.
For example, lets say there is a package 'mypack.' If this statement is returned as a ref cursor:
select col1,col2,myfunc(bob) from foo;
where 'myfunc' is in the current package mypack, this will cause a crash.
However, if you qualify the package name such as
select col1,col2,mypack.myfunc(bob) from foo;
This works fine.
We are using OCI 7, and this seems to be the case for the last 7-8 versions of DOA against Oracle 8.16.
Anyone else experience this?
I can supply better detail if needed.
Thanks,
John
We have an unusual problem with DOA, but we also have a fix.
Seems that with Oracle 8.16, if you use a local function call in the select statement for a ref cursor, it causes a crash.
For example, lets say there is a package 'mypack.' If this statement is returned as a ref cursor:
select col1,col2,myfunc(bob) from foo;
where 'myfunc' is in the current package mypack, this will cause a crash.
However, if you qualify the package name such as
select col1,col2,mypack.myfunc(bob) from foo;
This works fine.
We are using OCI 7, and this seems to be the case for the last 7-8 versions of DOA against Oracle 8.16.
Anyone else experience this?
I can supply better detail if needed.
Thanks,
John
