This discussion is archived
1 Reply Latest reply: Oct 23, 2012 8:56 AM by gdarling - oracle RSS

Converting from Microsoft ODBC for Oracle to the Oracle supplied driver

969939 Newbie
Currently Being Moderated
I have an old application that works when connecting to both a 10G and 11G Oracle database using the Microsoft ODBC for Oracle driver. However, I'd like to use the Oracle ODBC driver. Currently it works for some of the calls, but not others. The ones where it fails seem to be those where a user-defined type is included in the procedure definition. Below is a sample of the type and an excerpt of the procedure declaration from the package:

TYPE t_date_filled IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;

Proc (…
o_date_filled OUT t_date_filled,

)

The preceding works fine if the Microsoft driver is used, but gives the following error when I switch to the Oracle driver:
[Oracle][ODBC][Ora]ORA-06550: line 1, column 119; PLS-00201: identifier 'O_DATE_FILLED' must be declared.

Obviously the Oracle driver doesn't recognize the user defined type, but I'm not sure how to declare it to fix the problem.

Any suggestions are appreciated.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points