Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    4

    Unanswered: returning values from stord procedures

    Hi all
    i want to return some values like table from stord procedures
    is is possible plz help me
    thanks in advance

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    From a procedure? Then you should use an OUT parameter. Though, why wouldn't you rather use a function?

  3. #3
    Join Date
    Jan 2009
    Posts
    4
    i am new in oracle and plz help me how to us eout parameter using vb.net

  4. #4
    Join Date
    Mar 2008
    Posts
    89
    Quote Originally Posted by Cdigital
    i am new in oracle and plz help me how to use out parameter using vb.net
    You use the OUT parameter in the procedure:
    i.e.
    Code:
    Create Procedure (dummy1 IN number, dummy2 OUT varchar2) as
    [...]
    How you call this procedure from another language, however, is another story.
    "My brain is just no good at being a relational Database - my relations suck real bad!"

Posting Permissions

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