1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how to create procedure in 11g express edition ?

Discussion in 'SQL PL/SQL' started by jayadhana, Apr 22, 2012.

  1. jayadhana

    jayadhana Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    hello everyone,

    Actually I am learning pl/sql from past 1 month.I am practicing it in oracle 11g express edition.I am able to create procedure but I am not able to compile or execute it.I am getting simply error like " INVALID STATEMENT " .Kindly anyone help me please.


    Thanks you
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi jayadhana,

    Can you post what statement you are using to execute that procedure. If you post that we can help you in that.
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Please post this procedure and the error messages generated when attempting to compile it.