Sql procedure

Question

Hello guys. Need backup in creating sql procs. Can’t do something cuz it gives me a lot of errors.

Answer 1

hard to answer without any Code.

Answer 2

I'm not familiar with Oracle SQL and can't verify this, but I guess you can start by replacing the 'IS' on line 3 and 7 with 'AS'. What are r_estate and p_estate by the way?

(Edit)
IS is a valid keyword in Oracle SQL

Answer 3

create or replace PROCEDURE sum_tax
IS
begin
declare
cursor sum_cursor
is
SELECT tax_on_real_estate.payment, tax_on_personal_estate.payment, tax_on_real_estate.code_number, tax_on_real_estate.amount + tax_on_personal_estate.amount
FROM tax_on_real_estate, tax_on_personal_estate
WHERE tax_on_real_estate.code_number = tax_on_personal_estate.code_number;
open sum_cursor;
dbms_output.put_line (r_estate ||' '||p_estate);
close sum_cursor;
end sum_tax;

​

Answer 4

Idk what is wrong

Answer 5

It’s columns for outputting data

Answer 6

Guys, I really need your help

Answer 7

As you said there are a lot of errors. What kind of errors?

Answer 8

Such like pls00013