<div>
<div class="content wysiwyg-content">
Hi,<br />
I created this procedure<br />
<br />
CREATE OR REPLACE procedure upd_coeff as<br />
BEGIN<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;UPDATE BL <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET COEFF=(case when area_oc=0 or area_gr=0<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; then 0 <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;else (area_gr/area_oc) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;end);<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; commit;<br />
END;<br />
<br />
but when I compile I get error PLS-00103 on CASE clause.<br />
my oracle version is 8.1.7.0<br />
<br />
Thanks!!
</div>
</div>


Hi,
I created this procedure

CREATE OR REPLACE procedure upd_coeff as
BEGIN
	 	  UPDATE BL 
		  SET COEFF=(case when area_oc=0 or area_gr=0
	   	  	    then 0 
	   	            else (area_gr/area_oc) 
	   	   	    end);
		  commit;
END;

but when I compile I get error PLS-00103 on CASE clause.
my oracle version is 8.1.7.0

Thanks!!

PLS-00103 error in stored procedure!!!

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.