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!

Procedure.,

Discussion in 'SQL PL/SQL' started by Vicky, Feb 20, 2014.

  1. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Yes. Thanks, David. Can you tell me how to execute this procedure in applications other than sql plus like sql developer, isql plus., I tried to execute the procedure as below:

    declare
    x sys_refcursor;
    begin
    P1('emp', :x);
    end;

    But I'm not getting the output.., I'm getting the error as below:

    ORA-06550: line 4, column 2:
    PLS-00306: wrong number or types of arguments in call to 'P1'
    ORA-06550: line 4, column 2:
    PL/SQL: Statement ignored
    06550. 00000 - "line %s, column %s:\n%s"
    *Cause: Usually a PL/SQL compilation error.
    *Action: