On invoking the stored procedure with the name 'fox' - get_phoneno_by_name('fox'), one will generate the following two lines:
-
The office phone no. of Geoffrey Fox: 3154432163
-
The home phone no. of Geoffrey Fox: 3156827945
|
|
Note a cursor is used to hold the query results in memory for processing
|
|
htp.p is the invocation of a procedure p in a package htp to print out characters to stdout
|
|
When this procedure is created/compiled, all the objects referred in the procedure (e.g. the two tables) must be present and valid in the RDBMS
|
