Comments by greatwhite1 (Top 5 by date)

So I created a simple procedure to try and call with no luck. This is so easy to do in Microsoft. I am actually wondering now if you can even call procedures from SQL Dev. Are there add ons I need to the oracle database to accomplish this.

create or replace procedure My_login( IN_User_id number,out_p out varchar2)
is
begin
select app_users.user_name into out_p from app_users where user_id =IN_User_id;
end My_login;


--Call to procedure
set serveroutput on;
Declare
Answer varchar2(100);
begin

My_login(1976, :Answer);
dbms_output.putline(Answer);

End;

Tried the solutions and tried modifying them to suit my needs. I beginning to think what I am trying to do might not be possible.

I need every address that is a duplicate. and I need it's eval_id and house_id. Once I isolate these I will review them to see why they are duplicates. The current queries can't be right because the return of records is more than is possible.

No once I find the records I won't be deleting them they have to have their house_id updated to the original. From my understanding before I started here something caused some addresses to be given a new house ID , Duplicate data is normal but they should all have the same house_id. I know weird but I didn't build it, just have to live with it.

How do I include house_id? I have to have that so I can see if the house_id is different