[Error Code: 6550] while executing stored procedure

[Udara Rathnayake]

I'm trying following simple stored procedure using EQ connected to Oracle.

CREATE OR REPLACE PROCEDURE simpleProc
IS
BEGIN
 
 SELECT * FROM SOCIAL_COMMENTS;
 
END;
/



execute stored object returns,

Executing procedure SIMPLEPROC...

ORA-06550: line 1, column 14:
PLS-00905: object WARUNA.SIMPLEPROC is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[Error Code: 6550]
[SQL State: 65000]

Appreciate any help..

[Takis Diakoumis]

hi

can you try and execute it as a single statement by either the right-click menu item 'Execute as Single Statement' or just ctrl-shift-f5 for the shortcut.

let me know how you go.

thanks

Takis

 

--
You received this message because you are subscribed to the Google Groups "Execute Query" group.
To unsubscribe from this group and stop receiving emails from it, send an email to executequery...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

http://executequery.org

[Udara Rathnayake]

Hi Takis,

I'm able to run the CREATE statement without any issues, I'm getting this error while executing the stored object using Database>Execute Stored Object

[Takis Diakoumis]

ok... sorry, missed that. i'll have to spin up something i have with oracle to test.

in the meantime, have you tried executing this from the editor using:

call simpleProc;

thanks

Takis

[Udara Rathnayake]

Hi, I initially tried that... noticed the same error..

ORA-06550: line 1, column 14:
PLS-00905: object WARUNA.SIMPLEPROC is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[Error Code: 6550]
[SQL State: 65000]

[Takis Diakoumis]

yep - got it too... one sec... :)

[Udara Rathnayake]

So I believe this has nothing to do with EQ :) This happens while compiling the SP

[Takis Diakoumis]

ok. great. 

don't hesitate to post up anything else.

thanks

Takis