jump to navigation

[error] call create_inboxberkas June 29, 2010

Posted by nttsurvivor in KKP.
trackback

Pak/Ibu sewaktu menjalankan call create_inboxberkas() di benthic muncul pesan

ORA-06502 PSQL/SQL: numeric or value error: character string buffer too small
ORA-06512: at “BPNTEKSTUAL.AFTER_UPDATE_BERKASFLOW”, line 4
ORA-04088: error during execution of trigger ‘BPNTEKSTUAL.AFTER_UPDATE_BERKASFLOW’
ORA-06512: at “BPNTEKSTUAL.CREATE_INBOXBERKAS”,line 4
============
coba jalnkan sql ini di benthic

create or replace
TRIGGER After_update_berkasflow
after update ON BERKASFLOW
FOR EACH ROW
declare
vprofile VARCHAR2 (18);
BEGIN
vprofile :=:new.profileid;
if vprofile=’A10110′ then
vprofile:=’100110′;
end if;
if vprofile=’A90090′ then
vprofile:=’900090′;
end if;
update INBOXBERKAS
set profileid=vprofile,useridto=:new.useridto
where berkasid=:new.berkasid;
END;

Comments»

No comments yet — be the first.

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: