Need help determining what the problem is - ambiguously defined column?
Thanks in advance for reading this.
I have a function which builds a dynamic query and returns the ref_cursor. Variables are handled via sys_context. The problem that I'm having is, under a specific condition, I'm getting a "column ambiguously defined" error. The condition appears, I believe, when I'm using sdo_geometry() and str2tbln().
str2tbln is based off of the str2tbl function on asktom.com where I take a pipe separated list and convert it into a table so I can use it with an IN() statement.
Here is an example of the code:
select * from (
I have a function which builds a dynamic query and returns the ref_cursor. Variables are handled via sys_context. The problem that I'm having is, under a specific condition, I'm getting a "column ambiguously defined" error. The condition appears, I believe, when I'm using sdo_geometry() and str2tbln().
str2tbln is based off of the str2tbl function on asktom.com where I take a pipe separated list and convert it into a table so I can use it with an IN() statement.
Here is an example of the code:
select * from (
0