Oracle: what is an oracle precompiler?

Question

If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure?

Answer 1

An Oracle Precompiler is a programming tool that allows you to embed SQL statements in a high-level source program. The precompiler accepts the source program as input, translates the embedded SQL statements into standard Oracle runtime library calls, and generates a modified source program that you can compile, link, and execute in the usual way. examples are
Pro*C Precompiler for C, Pro*Cobol for Cobol and SQLJ for Java etc.

Answer 2

Oracle precompilers are application-development tools used to combine SQL statements for an Oracle database with programs written in a high-level language.

Oracle precompilers are compatible with ANSI SQL and are used to develop open, customized applications that run with Oracle9i or any other ANSI SQL database management system.

Oracle Precompilers are used to process C, COBOL, or PL/I programs before passing them to their native compilers. Oracle Precompilers translate embedded SQL statements into calls necessary to access the Oracle9i database server.