oracle - Getting extra messages while executing a trigger -

-


oracle - Getting extra messages while executing a trigger -

i'm facing problem while creating db trigger raise error message oracle forms. can please help me out?

my code is:

create or replace trigger unsuccessful_attempts_lock before update of last_logon_date on temp_user each row declare cursor c_unsuccessful_attempts select * temp_unsuccessful_attempts user_id=:new.user_id; max_fails exception; begin r_unsuccessful_attempts in c_unsuccessful_attempts loop if(r_unsuccessful_attempts.locked ='y') raise max_fails; end if; end loop; exception when max_fails fnd_message.set_name ('fnd', 'flex-user defined error'); fnd_message.set_token ('msg', 'you have reached maximum failed logins. business relationship has been locked temporarily. please contact scheme administrator') fnd_message.raise_error; when others raise_application_error(-20400,'an error has occured.please contact scheme administrator'||sqlcode||sqlerrm); end unsuccessful_attempts_lock;

once user's business relationship locked, temp_unsuccessful_attempts.locked updated 'y' , he/se should not able login further. , temp_user table gets updated when user has successful login.

so, 1 time user's acount locked(temp_unsuccessful_attempts.locked='y') , if he'll seek login right password, tis trigger should fire(upon updation of temp_user table) , form should give error business relationship locked , should not progress further.

message i'm getting is:

oracle error -20001: ora-20001: flex-user defined error:n, msg, have reached maximum failed logins. please contact scheme administrator.

ora-06512: @ "apps.fnd_message",line 66

ora-06512: @ "apps.unsuccessful_attempts_locks",line 38

ora-04088: error during excution of trigger 'apps.unsuccessful_attempts_locks' has been detected in fnd_signon.new_session.

my trigger giving message on oracle apps screen. want display

you have reached maximum failed logins.your business relationship locked temporarily.please contact helpdesk.

p.s: fnd_signon.new_session procedure temp_user.last_logon_date getting updated.

here utilize function get's first error of stack:

function strip_first_error(pcode in number, pmessage in varchar2) homecoming varchar2 -- vpos number := instr(pmessage, 'ora-', 5); -- begin if pcode between 20000 , 20999 if vpos != 0 return( substr(substr(pmessage, 1, vpos -2 ),12) ); else return( substr(pmessage,12) ); end if; else homecoming pmessage; end if; end;

and usage is:

when others message(strip_first_error(abs(sqlcode), sqlerrm));

edit

p.s.: when others handle errors in phone call of update. in specific illustration should be:

begin update last_logon_date ... exception when others -- in forms should utilize message or other function display error -- in pl/sql should utilize dbms_output.put_line, example. dbms_output.put_line( strip_first_error(abs(sqlcode) , sqlerrm) ); end;

oracle plsql triggers oracle-apps

Comments

Post a Comment

Popular posts from this blog

How do I check if an insert was successful with MySQLdb in Python? -

-
How do I check if an insert was successful with MySQLdb in Python? - i have code: cursor = conn.cursor() cursor.execute(("insert new_files (videos_id, filename, " "is_processing) values (%s,%s,1)"), (id, filename)) logging.warn("%d", cursor.rowcount) if (cursor.rowcount == 1): logging.info("inserted values %d, %s", id, filename) else: logging.warn("failed insert values %d, %s", id, filename) cursor.close() fun is, cursor.rowcount always one, though updated database create videos_id unique key. is, insert fails because in tests same videos_id going appear (and when check database, nil inserted). whatever reason, rowcount 1 - logging.warn have spits out rowcount of 1. so, question: can utilize rowcount work out if insert went fine? if so, (presumably) doing wrong? otherwise, how check if insert went fine? your code not commit after modifications (your modifications rolled back). should...
Read more

delphi - blogger via idHTTP : error 400 bad request -

-
delphi - blogger via idHTTP : error 400 bad request - i'm trying post blogger using idhttp component, however, i'm getting "http/1.0 400 bad request" error. procedure tform1.button1click(sender: tobject); var request,response,req : tstringlist; auth,blogid : string; begin blogid := '00000000000000000000000'; request := tstringlist.create; response := tstringlist.create; req := tstringlist.create; idhttp1.request.connection := 'keep-alive'; idhttp1.request.contenttype := 'application/x-www-form-urlencoded'; idssliohandlersocket1.ssloptions.method := sslvsslv23; request.clear(); request.values['accounttype'] := 'google'; request.values['email'] := 'xxx@gmail.com'; request.values['passwd'] := 'yyy'; request.values['service'] := 'blogger'; response.text :=idhttp1.post('https://www.google.com/accounts/clientlogin',request); auth := resp...
Read more

postgresql - ERROR: operator is not unique: unknown + unknown -

-
postgresql - ERROR: operator is not unique: unknown + unknown - i have postgis database , have compute new values rows in new column. these values should average of values of several columns. query: insert bdps (da_m) values (avg('da_1'+'da_2'+'da_3'+'da_4'+'da_5'+'da_6'+'da_7')); in query bdps database, da_m new column , da_1 da_7 existing columns have double precision type. da_m created using alter table bdps add together column da_m double precision; i next error: error: operator not unique: unknown + unknown line 2: values (avg('da_1'+'da_2'+'da_3'+'da_4'+'da_5'+'da_6'+'da_7... ^ hint: not take best candidate operator. might need add together explicit type casts. ********** error ********** error: operator not unique: unknown + unknown sql state: 42725 hint: not take best candidate operator. might need add togethe...
Read more