New problems w/ 6.0.4???

[Stew Stryker]

I just upgraded and I'm seeing something very strange when I try to run an anonymous block from w/in a SQL window. If that anon block has a local procedure or function defined in it, it will NOT run!

Gives error like:

ORA00103 - encounterd the symbol "end-of-file" when expecting one of the following:

    ; return

I know I used to be able to run these in a SQL window. Now it will only run (and give output) in a Test Window.

Is this a feature or a bug?

Here's a quicky sample of what fails.

DECLARE

    PROCEDURE get_sample_id_pf_total_life IS
    BEGIN
        NULL;

    END get_sample_id_pf_total_life;

BEGIN
    dbms_output.put_line('test');
END;

What's up with this???

Stew

 

[LMW]

Hello,

If you select the whole source in the sql-window and then execute , the anonymous block will succeed,

or you have to disable option "auto select statement" in the preferences (which has been obviously enabled during the installation of 6.0.4)

Wilhelm

 

[Marco Kalter]

This is actually a new bug introduced in 6.0.4. If you have enabled the "Auto Select Statement" preference, and want to executed a PL/SQL Block with a local function or procedure declaration, then you will get this error. The workaround is to disable the preference or to explicitly select the PL/SQL Block before execution.

 

[Stew Stryker]

Wilhelm and Marco,

Thanks for the easy workaround to select the entire block. That'll do the trick nicely until a fix gets released.

Stew