Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the...

Assignment Two:<br>We will write three procedures on our tables,<br>the first of which I<br>have provided as an example.<br>proclnsertPlayer takes one IN VARCHAR(16)<br>paramater and returns<br>an error code in the second SMALLINT (INOUT)<br>parameter.<br>The procedure checks the parameter and, if<br>there are no errors,<br>inserts the value into tblPlayers.<br>Documentation of errors<br>Condition<br>Error code<br>No errors<br>1st param Null or zero len<br>playerID taken<br>1<br>proclnsertGame will receive two IN<br>VARCHAR(16) interpreted as<br>

Extracted text: Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the second SMALLINT (INOUT) parameter. The procedure checks the parameter and, if there are no errors, inserts the value into tblPlayers. Documentation of errors Condition Error code No errors 1st param Null or zero len playerID taken 1 proclnsertGame will receive two IN VARCHAR(16) interpreted as

Jun 03, 2022

SOLUTION.PDF

Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment