My team is upgrading to Oracle 11g. We have an Oracle stored procedure that has 9 inputs and 20 outputs. We have a classic ASP web pages that executes the stored procedure, and displays its results. We connect to the database using Microsoft ODBC v.2.576.3959.00.
With the upgrade to 11g, it seems our ASP page no longer works. Here's what I need you to do:
1) Create a simple stored procedure in Oracle 11g that takes 9 input values (you can use numbers) and produces 20 results. The results should be:
9 values equal to the input values
9 values equal to 2 X the input values
YES and NO
So, for example, if you called the SP and fed it the numbers 1 - 9, it would return: 1,2,3,4,5,6,7,8,9,2,4,6,8,10,12,14,16,18, YES, NO
2) Connect using the same ODBC driver specified above
3) Create a classic ASP page that executes the SP and displays the results.
That's it. It doesn't have to be pretty, but it does have to work, and the versions must match the above. If you don't like the $30 price, tell me what you do like.