Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling Procedure from SQL Developer

AntillesJul 23 2008 — edited Jul 23 2008
Could anyone tell me how to call a Procedure from a SQL Worksheet using SQL Developer?

I can run by right clicking the Procedure in the Connections window, but want to call it using SQL commands.

I can run it using EXECUTE procedurename in SQL Plus but I get an ORA-00900 - invalid SQL statement if I try this in a SQL Worksheet. If I try CALL procedurename, I get an ORA-06576 - not a valid procedure or function name.

Am I doing something daft (I've been using Oracle for 3 days)?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2008
Added on Jul 23 2008
#general-database-discussions
1 comment
4,560 views