What is Pro*C ? Why use ?

• What is Pro*C ?
• Why ?

What tools you need?

Pro*C – compilation process

• Compilation process
• Few Restrictions

Pro*C – Writing code

• Types of Embedded SQL statements
  • Executable statements
  • Declarative statements
• Syntax for Embedded SQL statements
• Sample Pro*C Program
• Declaring variables
  • Pointers
• Header files for embedded SQL statements
• Example program

Pro*C – Error Handling

• WHENEVER Statement
• Explanation
  • Example
  • Scope issue with WHENEVER Statement
• SQLCA
• Example Program

Pro*C – List of Embedded SQL statements

• List of Embedded SQL Statements Supported by Pro*C

Pro*C – more concepts