When I create a table using an execute immediate statement in the procedure, the procedure will compile but is not executed. Why?

    Requires Free Membership to View

    Login

A stored procedure is an object in your schema. When you issue a CREATE PROCEDURE command, you are just creating the stored procedure, not executing it. To execute the stored procedure in SQL*Plus, you can issue the following: 
exec stored_proc_name(param1,param2,...,paramN)

This was first published in June 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top