The solution to the 24344 error of navicat executing oracle function footer

This article will explain in detail about navicat execution oracle function script reported 24344 error solution, Xiaobian think quite practical, so share to everyone for a reference, I hope you can read this article after harvest.

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

This stored procedure means entering information about the top few employees with the highest salary (parameter value) as an integer parameter.

create or replace procedure my_p (v_n in number) iscursor 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 selected"

3. If the following message appears, there is no problem with the software. It's our (your) code that's broken.

Then this time you need to check our (your own) code, such as dbms output field name connection string, there is no double vertical line, there should be no semicolon added. At this point, 90% of my friends 'problems are basically solved.

4. If not, try this:

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

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

5. When you run the code again, 93.57% of your friends 'problems should be solved.

tips：

A. I tried the capitalization problem on the Internet and it didn't affect me. However, the specificity of the Navicat version is not excluded. I'm using Navicat version 12.1 here.

b. The remaining 6.43% of the problems are not solved, and may be other problems. Generally, after doing the above methods, they will be basically solved.

c. Remember to select the database and user. This can lead to problems with permissions and so on.

About "navicat execution oracle function script reported 24344 error solution" This article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.