Trouble passing exceptions

[mike]

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

[mike]

Sorry, I posted this in the wrong forum.

This is NOT about tools...

[Noel]

Użytkownik mike napisał:
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

Update doesn't raise no_data_found.

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

IF SQL%ROWCOUNT = 0 THEN
RAISE NO_DATA_FOUND;
END IF;
-- raise_application_error(-20101, 'No Data');
end update_me;

--
Noel




--
TomekB tbal@spam_go2_trap.pl GSM:Plus 607598532
{Peugeot 306 ST, WY - 49245, GG: 947-891}