Click here to Skip to main content
15,072,391 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an application that is running smoothly.

A .net 2008 web based apps using Oracle 10g packages.

Recently, our IT Dept upgrade our oracle database from 10g to 11g then
after that my application hang-up. So, I simulate the apps to see the problem then
I found out that the problem is the package that accepting parameter for the in-clause condition. In my package, I parse the parameter and cast it to type table.


where fieldname in (select * from the (select cast(str2tbl(parametername) as table_type) from dual)

str2tbl is a function to parse the parameter and convert to table type.

Its working fine in Oracle 10g but it didnt work in 11g.

So, I decided to use INSTR instead of IN-Clause.

What I want to know is if this is a bug or what.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900