Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: execute a procedure

    Hi everybody
    Does any body know how to execute this procedure?
    Actually i converted a procedure from sql server to oracle using 'oracle migration work bench'. The procedure is created like this.
    I dont know how to execute this
    Please help

    CREATE OR REPLACE PROCEDURE SOURCELIST(
    RC1 IN OUT Omwb_emulation.globalPkg.RCT1)
    AS
    StoO_selcnt INTEGER;
    StoO_error INTEGER;
    StoO_rowcnt INTEGER;
    StoO_crowcnt INTEGER := 0;
    StoO_fetchstatus INTEGER := 0;
    StoO_errmsg VARCHAR2(255);
    StoO_sqlstatus INTEGER;
    BEGIN
    OPEN RC1 FOR

    SELECT SourceId
    , SourceName
    FROM Source;
    END SOURCELIST;
    /

    Thanks all

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    In SQL Plus:

    var rc refcursor

    exec sourcelist(:rc)

    print rc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •