Oracle B25-317-01 Bedienungsanleitung PDF herunterladen (Seite 67)

Using PL/SQL Ref Cursors to Return Result Sets

Beta Draft Executing Stored Procedures and Functions 6-5

</tr>

END;

// Write one row per employee

foreach ($employeerecords as $emp) {

echo '<tr>';

echo '<td><input type="radio" name="emprec"

value="'.htmlentities($emp['EMPLOYEE_ID']).'"></td>';

echo '<td align="right">'.htmlentities($emp['EMPLOYEE_ID']).'</td>';

echo '<td>'.htmlentities($emp['EMPLOYEE_NAME']).'</td>';

echo '<td>'.htmlentities($emp['HIRE_DATE']).'</td>';

echo '<td align="right">'.htmlentities($emp['SALARY']).'</td>';

echo '<td align="right">'.htmlentities($emp['COMMISSION_PCT']).'</td>';

echo '<td align="right">'.htmlentities($emp['REMUNERATION']).'</td>';

echo '</tr>';

}

13. Save the changes to your application files. In a browser, enter the following URL to

test the application:

http://localhost/~<username>/chap6/anyco.php

14. In the Departments form, click Show Employees.

In the Employees page for the department, the employee remuneration is

displayed in the last column:

Using PL/SQL Ref Cursors to Return Result Sets

Data sets can be returned as REF CURSORS from PL/SQL blocks in a PHP script. This

can be useful where the dataset requires complex functionality.

A REF CURSOR in PL/SQL is a type definition that is assigned to a cursor variable. It

is common to declare a PL/SQL type inside a package specification for reuse in other

PL/SQL constructs, such as a package body.

To create a PL/SQL package specification and body, with a REF CURSOR to retrieve

employees for a specific department, perform the following steps:

1 2 ... 62 63 64 65 66 67 68 69 70 71 72 ... 93 94

Keine Kommentare

Oracle B25-317-01 Bedienungsanleitung Seite 67