Database Error Code 1403
Contents |
on OracleWhere is this place located?All Places SAP on Oracle 10 Replies Latest reply: Sep 28, 2013 12:52 PM by Stefan Koehler Tweet ReturnCode -1403 M. Abdul Jamil Sep bufman error 1403 9, 2013 1:18 PM Currently Being Moderated Dear All,FI users are facing sql error code 1403 delay when they are trying to save the data in F-29. Please check the attached trace and ora-01403 no data found in oracle guide me about rectification of this error ReturnCode -1403.while system is running on window server 2008 with Oracle 10.2.0.5Regards, 1403.png 89.1 K 1433Views Tagsnone (add) Topics: database Tags: error, ora-01403 no data found select into oracle, 10g Re: ReturnCode -1403 Reagan Benjamin Sep 9, 2013 1:42 PM (in response to M. Abdul Jamil) Currently Being Moderated HelloCheck the Oracle alert log for ORA-01403 errors.RegardsRB Alert Moderator Like (0) Re: ReturnCode -1403 M. Abdul Jamil Sep 9, 2013 2:05 PM (in response to Reagan Benjamin) Currently Being Moderated Dear,I just checked and find
Ora 01403 No Data Found In Forms
the ORA-1403 in alert log but there are nothing showing which relates to this error.Regards, Alert Moderator Like (0) Re: ReturnCode -1403 Abhi K Sep 9, 2013 2:04 PM (in response to M. Abdul Jamil) Currently Being Moderated Hi Jamil,Could you please check the SM21 log as well of the same timestamp when you ran trace? ThanksA. Kumar Alert Moderator Like (0) Re: ReturnCode -1403 Marius Burger Sep 9, 2013 3:19 PM (in response to Abhi K) Currently Being Moderated Hi JamilAs requested check the SM21, and see if there is more details about the error, also is the update running to an external database ?if so please have a look at the following note : Note 1506867 - DBSL error in secondary connectionBest RegardsMarius Alert Moderator Like (1) Re: ReturnCode -1403 M. Abdul Jamil Sep 9, 2013 6:55 PM (in response to Marius Burger) Currently Being Moderated hi Marius,there are no more detail in SM21. while only one database is installed on server mean i did not make the seconda
easiest fix would be is to handle the error in the PL/SQL block, When a SQL statement is
Ora-01403 Trigger Raised
written within a PL/SQL block, enclose the SQL with a BEGIN ora-01403 no data found in package and END statement. Handle the exception and raise a user-friendly message or handle the rest of ora-01403 no data found in oracle apps the processing. Eg: CREATE OR REPLACE PROCEDURE test_proc (p_empno IN NUMBER) IS l_empname VARCHAR2(50); BEGIN SELECT empname INTO l_empname FROM emp WHERE empno = p_empno; IF l_empname = https://scn.sap.com/thread/3419811 'Sarah Jones' THEN INSERT INTO empresult values ('105', 'Found Sarah Jones'); END IF; END; / The above procedure has not handled the error that would be raised if the select statement did not find the specified empno. See the following for the error raised: SQL> exec test_proc (1) begin test_proc (1); end; * ERROR at line http://www.orafaq.com/wiki/ORA-01403 1: ORA-01403: no data found ORA-06512: at "TAROT.TEST_PROC", line 4 ORA-06512: at line 1 If you want the procedure to execute properly without errors on the screen, then you would have to handle the error. The Exception needs to be controlled by adding an exception handler to the code. The above code has been modified to handle an exception NO_DATA_FOUND. This is the name of the exception that the error relates to. CREATE OR REPLACE PROCEDURE test_proc (p_empno IN NUMBER) IS l_empname VARCHAR2(50); BEGIN SELECT empname INTO l_empname FROM emp WHERE empno = p_empno; IF l_empname = 'Sarah Jones' THEN INSERT INTO empresult values ('105', 'Found Sarah Jones'); END IF; EXCEPTION WHEN NO_DATA_FOUND THEN INSERT INTO empresult values(p_empno, 'Did not find Sarah Jones'); END; / If you execute the above procedure now, this is what you would see: SQL> exec test_proc (1) PL/SQL procedure successfully completed. SQL> select * 2 from empresult; EMPNO EMPNAME --------- -------------------------------------------------- 1 Did not find Sarah Jones As the exc
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login https://www.experts-exchange.com/questions/22811602/Pro-C-SQLCA-sqlcode-1403-No-row-found-BUT-THE-ROW-IS-THERE.html Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Pro C SQLCA.sqlcode = 1403 "No row found" BUT THE ROW IS THERE! Want to Advertise Here? Solved Pro C SQLCA.sqlcode = 1403 "No row found" BUT THE ROW IS THERE! Posted on 2007-09-06 C Programming Oracle Database 1 Verified Solution 20 Comments 14,896 Views Last Modified: 2008-02-07 HI everyone, I have a service written in PRO C that is no data doing a simple Select from a table. I have debugged it to make sure that the parameters that are being passed are correct. I get a return sqlca.sqlcode of 1403 but the when I run the sql statement in sql plus, the row is there! Is there anything else that I should be checking? I have debug statements outputting the parameters which are absolutely correct. I have no clue where else to look. Thank you for your help no data found in advance. 0 Question by:farekat Facebook Twitter LinkedIn Google LVL 53 Best Solution byInfinity08 As I asked before, what does mvtovc do ? Where and how is q_order_num defined ? And can you also try to fill in some literal values : EXEC SQL SELECT ROWIDTOCHAR(rowid) Go to Solution 20 Comments LVL 53 Overall: Level 53 C 35 Programming 12 Oracle Database 1 Message Expert Comment by:Infinity082007-09-06 Can you show the relevant code, as well as the SQL statement that works when you play it directly ? 0 Message Author Comment by:farekat2007-09-06 EXEC SQL SELECT ROWIDTOCHAR(rowid) INTO :host_row:host_row_i FROM queue WHERE store_num = :q_store_num AND order_num = :q_order_num AND line_num = :q_ln_num FOR UPDATE; This is the pro c code. This is the code that i run in sql plus: SELECT ROWIDTOCHAR(rowid) FROM queue WHERE store_num = 3000 AND order_num = 'T3051' AND line_num = 5 I plug in the values I see in the debugger. Thanks 0 LVL 53 Overall: Level 53 C 35 Programming 12 Orac