Error when executing procedures

ShayP

Member
I'm fairly new to your application and am used to running things through the standard OEM or through an SSH.

I've created a procedure within a package and I know the syntax is correct. It compiles fine and I can run it through the OEM without an issue. However when I try to execute it in a sql window in your application I am getting a ORA-00900 error.

The syntax I'm using is:

execute spacename.packagename.procedure;
 
To use 'execute ...' syntax you need to run it in Command Window

If you want to run your stored procedure in SQL Window, you will need to change syntax to

Code:
begin
    spacename.packagename.procedure;
end;
 
Back
Top