Toad World® Forums

Beta 2: Package Body compilation problem

This piece of code says: ORA-00900: invalid SQL statement

Although it shouldn’t. And does not in 7.0.1.

CREATE OR REPLACE PACKAGE BODY mpa_test_pkg
IS
PROCEDURE test_1
IS
BEGIN
FOR r IN (SELECT 1 FROM DUAL)
LOOP
IF 1 = 2 THEN
NULL;
END IF;
END LOOP;
END test_1;

PROCEDURE test_2
IS
BEGIN
NULL;
END;
END mpa_test_pkg;
/

Martin, you are right. A recent change causes this problem. SQLNAV-1583 is now created and we will fix it asap.

From: MPAX [mailto:bounce-MPAX@toadworld.com]

Sent: Tuesday, 22 April 2014 10:37 PM

To: sqlnavbeta@toadworld.com

Subject: [SQL Navigator - Beta Discussion Forum] Beta 2: Package Body compilation problem

Beta 2: Package Body compilation problem

Thread created by MPAX

This piece of code says: ORA-00900: invalid SQL statement

Although it shouldn’t. And does not in 7.0.1.

CREATE OR REPLACE PACKAGE BODY mpa_test_pkg

IS

PROCEDURE test_1

IS

BEGIN

  FOR r IN (SELECT 1 FROM DUAL)

  LOOP

     IF 1 = 2 THEN

        NULL;

     END IF;

  END LOOP;

END test_1;

PROCEDURE test_2

IS

BEGIN

  NULL;

END;

END mpa_test_pkg;

/

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from SQL Navigator - Beta
notifications altogether.

SQL Navigator - Beta Discussion Forum

Flag
this post as spam/abuse.

Hi Martin,

This issue should be fixed in beta3, please feel free to let us know if any problems.

www.toadworld.com/…/21915.aspx

Thanks,

Shirly