Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
automicss
automicss asked in Computers & InternetProgramming & Design · 1 decade ago

How to Call stored procedure oracle See the example..?

Hello, I have just completed the following http://www.techonthenet.com/oracle/questions/curso...

And now I wonder how I can run this procedure from pl/sql command line

Please help me out, this should be fairly easy..

Update:

davek, the example you provided runs but I can't see the results how can I output them?

Update 2:

^ "how can i output them" the cursor :)

Update 3:

lol ok, never worked with cursors so I'll google how to process an opened cursor

2 Answers

Relevance
  • davek
    1 decade ago
    Favorite Answer

    Not 100% sure, but this might work:

    declare

    c1_out winepkg.wine_type;

    begin

    find_wine2 ( 'col1_in_text', 'col2_in_text' , 'col3_in_text' , c1_out );

    end;

    /

    If find_wine2 in inside a package, do package_name.find_wine2.

    PSOUG ftw!

    Source(s): http://psoug.org/reference/anonymous_blocks.html
  • TheMadProfessor
    Lv 7
    1 decade ago

    Your example returns an opened cursor...you should be able to process it just like any other one.

Still have questions? Get your answers by asking now.