Trouble passing exceptions

Noel · *nix forums addict Joined: 25 Mar 2005 Posts: 67

Użytkownik mike napisał:

mike · *nix forums Guru Wannabe Joined: 04 Mar 2005 Posts: 233

Sorry, I posted this in the wrong forum.

This is NOT about tools...

mike · *nix forums Guru Wannabe Joined: 04 Mar 2005 Posts: 233

I'm pretty new to pl/sql and having trouble passing exceptions between
my sql and procedures.

I have my basic sql:

begin
update_me('param1','param2', ....);
exception when no_data_found then
insert_me('param1','param2', ....);
end;

my procedures are:

create or replace procedure update_me (
x_param1 in varchar2,
x_param2 in varchar2,
) AS
begin
UPDATE mytbl
SET myfield2 = x_param2,
WHERE myfield1 = x_param1;
exception when no_data_found then
raise_application_error(-20101, 'No Data');
end update_me;

The raise_application error is not being received, because I have know
data that is not getting inserted.

Any help is appreciated.

Mike

Google