DECLARE v_employee_name VARCHAR2(100); BEGIN BEGIN SELECT employee_name INTO v_employee_name FROM employees WHERE employee_id = :p_employee_id; -- 假设 :p_employee_id 是传入的参数 EXCEPTION WHEN TOO_MANY_ROWS THEN DBMS_OUTPUT.PUT_LINE('Error: ORA-01422 - More than one row returned by...
ORA-01422: exact fetch returns more than requested number of rows. When attempting to open Purchase Order Summary form, following error occurs. APP-PO-14142: Get_Employee-: ORA-0000: normal, successful completion Cause: A SQL error has occurred in GET_Employee. The SQL error is ORA-0000: ...
I am executing an Oracle stored procedure from SSIS script task and the package used to execute successfully without any issues. However, it started to fail with an ORA-01422 error suddenly. There were no package changes, stored procedure changes or config changes from where the ...
Error as seen in the concurrent request log:Error -Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at "APPS.PO_PDOI_GRP", line 398ORA-06512: at line 1ERROR from FND Logging:sid:4369332: To get the log messages for PDOI, please use the ...
解决此问题后,发现报了另外一个错误: 1 ORA-04088: error during execution of trigger '...' 2 www.2cto.com ORA-01403: no data found 3 ORA-06512: at line 5 加入如下异常处理语句后解决: 1 EXCEPTION 2 WHEN NO_DATA_FOUND 3 THEN 4 ...登录...
Help Center Home Oracle.com Home Get started with Cloud Help Center Database Error Messages Oracle Account Manage your account and access personalized content.Sign up for an Oracle Account Sign in to my Account Sign in to Cloud Access your cloud dashboard, manage orders, and more.Free Cloud ...
[Error][1] at line 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 27 解决方案: You are grouping by and if you have 2 different values an error will rise since you cannot insert 2 rows into a variable. Maybe you should not group by those co...
ORA-01422 :fetch returns more than requested number of rows In my previous articles, I have given the proper idea of different oracle errors, which are frequently come. In this article, I will try to explain another common error, which has been searched
What i would like to know is what exactly is the reason for this error to occur, and what would be the means to fix this error? I've done some research on the topic, and found this to be the common theme of my search: 1.There's a bug in the code and the developer did not ...
And there was more than one record in the suppliers table with the supplier_name of IBM, you would receive the ORA-01422 error message. In this case, it might be more prudent to create a cursor and retrieve each row if you are unsure of how many records you might retrieve....