Title: RE: Branching logic in PL/SQL, positive instead of exception
As an extension of this conversation, if I have eight conditional queries, eg.:
for i_row in main loop
build sql
declare cursor a select stuff
for a_row in a loop
if a%found
do stuff
elsif a%notfound
declare
12:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Branching logic in PL/SQL, positive instead of
exception
Hello,
I'm looking for an example of structured PL/SQL code that does not use
exception logic
Title: Branching logic in PL/SQL, positive instead of exception
Hello,
I'm looking for an example of structured PL/SQL code that does not use exception logic for branching, but instead recognizes that data is found.
As a bad example,
Select col1 from test.table t where exists (select
Title: Branching logic in PL/SQL, positive instead of exception
I
believe something like this might work.
DECLARE
cursor test_csr is
SELECT
col1
FROM test.table t
WHERE
exists(
SELECT z.zip
FROM
zip_table
WHERE
t.zip = zip);
BEGIN
OPEN test_csr;
/* This step tests if any
Use SQL%found
It's in the manual. :)
Jared
Hagedorn, Linda [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/13/02 12:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Branching logic in PL/SQL