Toad World® Forums

Beta 4: Package compilation error


#1

The following code is causing an error:

CREATE OR REPLACE PACKAGE mpa_test_pkg
AS
PROCEDURE test_proc;
END;

CREATE OR REPLACE PACKAGE BODY mpa_test_pkg
IS
PROCEDURE test_proc
IS
l_temp VARCHAR2 (1);
BEGIN
WITH q AS (SELECT ‘X’ AS val FROM DUAL)
SELECT q.val
INTO l_temp
FROM q;

IF l_temp IS NOT NULL
THEN
DBMS_OUTPUT.put_line ('Value: ’ || l_temp);
END IF;
END test_proc;
END mpa_test_pkg;

[1]: ORA-24344: success with compilation error
[1]: 16/17 PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:
[1]: begin end function pragma procedure

Compiles normally on v.7.0.1.


#2

Hi Martin,

Thanks for picking up this error. I have added it to SQLNAV-1641. The issue has been fixed internally. We may push another beta release soon.

Thanks,

Vincent


#3

Hi Martin,

This error has been fixed in the latest beta. You can download and try it out. We really appreciate the feedbacks. You guys with smart eyes and sufficient practical
scenarios help us a lot to stop delivering bugs like this to public. Thanks again.

Vincent