Book a Demo

Author Topic: ODBC Import from Oracle - Functions  (Read 3401 times)

nwray

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
ODBC Import from Oracle - Functions
« on: March 26, 2007, 08:08:51 am »
I tried importing from Oracle 10 using ODBC this morning - I was a little disappointed that there doesn't seem to be any way to import Functions.  When I ran the import, I saw only Procedures, Tables and Views.  None of the functions in the schema were listed, although I was able to manually create a "procedure" with a return type.  For anyone who doesn't know, the difference being that a procedure in Oracle doesn't return a value, whereas a Function does.

It seems like an oversight that it literally is looking for procedures and leaves out functions.