From Venu

</pre>
CREATE OR REPLACE PROCEDURE "METER"."COPY_ERROR_CODE_DESCRIPTION" AS

v_id varchar2(32);
 v_error_code varchar(32);
 v_error_desc varchar2(255);

cursor c_error is
 select id from ERROR_CODE_MAPPINGS;

begin
 open c_error;
 loop
 fetch c_error into v_id;
 exit when c_error%notfound;

select error_code, error_description into v_error_code, v_error_desc from ERROR_CODE_MAPPINGS_BACKUP where id = v_id;

dbms_output.put_line(v_id ||' :: ' ||v_error_code ||' :: ' ||v_error_desc);
 update ERROR_CODE_MAPPINGS set error_description = v_error_desc where id = v_id;

end loop;
 close c_error;

end;
<pre>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: