In the following procedure, what do the 2 lines (in blue color) do or what do they mean?
CREATE OR REPLACE PROCEDURE TryParamSP4(
iID IN Try.ID%TYPE)
IS
CURSOR CursorTry (curID int)
IS
SELECT * FROM Try WHERE ID=iID;
curTry CursorTry%ROWTYPE;
BEGIN
...............
...............
...............
END TryParamSP4;
Also can anyone suggest at least one website, if not a few, which provides tutorials in using Cursors in Oracle?
Thanks,
Arpan
CREATE OR REPLACE PROCEDURE TryParamSP4(
iID IN Try.ID%TYPE)
IS
CURSOR CursorTry (curID int)
IS
SELECT * FROM Try WHERE ID=iID;
curTry CursorTry%ROWTYPE;
BEGIN
...............
...............
...............
END TryParamSP4;
Also can anyone suggest at least one website, if not a few, which provides tutorials in using Cursors in Oracle?
Thanks,
Arpan