What should I do if navicat reports error 24344 when executing the oracle function script?

1. Create a new SQL query window in Navicat and enter the following stored procedure.

The meaning of this stored procedure is to take an integer as a parameter and enter the information of the top few (parameter values) employees with the highest salary.

create or replace procedure my_p (v_n in number) is
cursor csr is select * from emp order by sal DESC;
i number :=0;
begin
 for v_emp in csr loop
 i := i+1;
 dbms_output.put_line(v_emp.ENAME || '--' || v_emp.SAL);
 if i = v_n then
 exit;
 end if;
 end loop;
end;

2. Select the above code --> "Run the selected"

Related recommendations: "Navicat for mysql usage pictures and texts Tutorial》

3. If the following information appears, it means there is no problem with the software. It's our (yours) code that has a problem.

Then you need to check our (your own) code at this time. For example, when the field name is connected to the string when the dbms outputs it, are there any double vertical bars and the appropriate points? Has the number been added? Usually at this point, 90% of your friends’ problems are basically solved.

4. If it doesn't work, you can only try this method:

On the left side of the window, click on your user, such as my SCOTT user.

Then double-click our EMP table (the table you need to operate). The specific principle is not clear, but after doing it yourself, there will be no compilation errors. , maybe Navicat needs to preload data?

#5. Run the code again. At this time, 93.57% of your friends’ problems should be solved.

tips:

a. I have tried the capitalization issues mentioned online and it has no effect. But the particularity of the Navicat version cannot be ruled out. I am using Navicat12.1 version here.

b. The remaining 6.43% of the problems have not been solved. They may be other problems. Generally, after following the above methods, they will basically be solved.

c. Remember to select the database and user. This will cause issues such as permissions.

The above is the detailed content of What should I do if navicat reports error 24344 when executing the oracle function script?. For more information, please follow other related articles on the PHP Chinese website!