| 2. Create PL/SQL Function To Call Java Class |
| 3. Testing your Java Code (test as any Oracle PL/SQL function) |
| Oracle table row count using Java (JDBC with default or currently opened connection). The "Connection" code can be revised to connect to the database from an external application |
| 1. Create Java class named "OraObjRowcount" |
| 2. Create PL/SQL Function To Call Java Class (returns a NUMBER) |
| 3. Testing your Java Code (pass TABLE_NAME as the parameter) |
| The above code refined to show useful output |
| 1. Create Java class named "OraTableRowcount" |
| 2. Create PL/SQL Function To Call Java Class (returns a string - VARCHAR2) |
| 3. Testing your Java Code (pass TABLE_NAME as the parameter) |
| For corrections or feedback, other useful links please contact webmaster |