take a look at "pro c" link provided

I haven't worked with this stuff in ages--like seven years or more. From what little I recall, the Oracle application generators and SQL*Forms philosophy used PL/SQL for nearly all logic.

I do not believe that there was any way to "automate" or interface with the forms themselves outside of hokiness like DDE.

Of course, that was then.

My suggestion would be to see if the business logic does, in fact, reside in PL/SQL packages. If so and if sufficient documentation (or time to reverse-engineer) exists, then you will be able to interface with just about any language that can access the PL/SQL via the OCI.

*** EDIT BEGINS HERE ***

Oops. Sorry. I realize now that you are asking specifically about Oracle Applications rather than some homegrown Oracle applications--a mental prejudice that has built-up over the years while working HR systems.

Although as I understand it through hearsay, except for Oracle Financials, Oracle Applications are about like homegrown Oracle applications, so my suggestion still stands. Please temper your acceptance of it with the knowledge that I have *no* direct experience whatsoever.

*** EDIT ENDED ***

-Mike

Post #68,490 by boxley 12/12/02 8:23:40 PM Reply	take a look at "pro c" link provided [link\|http://www-db.stanford.edu/~ullman/fcdb/oracle/or-proc.html\|http://www-db.stanfo...acle/or-proc.html] thanx, bill will work for cash and other incentives [link\|http://home.tampabay.rr.com/boxley/resume/Resume.html\|skill set] I was so poor growing up ... if I wasn't a boy ...I'd have nothing to play with. --Rodney Dangerfield
Post #68,565 by bluke 12/13/02 1:38:23 AM Reply	Not exactly what I am looking for I know I can access the database from a C or Java program. However, with Oracle Apps I don't want to access the database directly but rather a higher level API that represents the business functions in Oracle Apps.
Post #68,567 by morganek 12/13/02 2:31:37 AM 12/13/02 1:49:20 PM Reply	Really old experience I haven't worked with this stuff in ages--like seven years or more. From what little I recall, the Oracle application generators and SQLForms philosophy used PL/SQL for nearly all logic. I do not believe that there was any way to "automate" or interface with the forms themselves outside of hokiness like DDE. Of course, that was then. My suggestion would be to see if the business logic does, in fact, reside in PL/SQL packages. If so and if sufficient documentation (or time to reverse-engineer) exists, then you will be able to interface with just about any language that can access the PL/SQL via the OCI. EDIT BEGINS HERE * Oops. Sorry. I realize now that you are asking specifically about Oracle Applications rather than some homegrown Oracle applications--a mental prejudice that has built-up over the years while working HR systems. Although as I understand it through hearsay, except for Oracle Financials, Oracle Applications are about like homegrown Oracle applications, so my suggestion still stands. Please temper your acceptance of it with the knowledge that I have no direct experience whatsoever. * EDIT ENDED * -Mike Edited by morganek Dec. 13, 2002, 01:49:20 PM EST Expand All History

Welcome to IWETHEY!