DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: storedprocedure

  1. 06-12-2002, 07:54 AM #1
    kavithared
    kavithared is offline Member
    Join Date
    May 2002
    Posts
    232
    Hiiii,any one can help me
    I have 2 Db servers like x and y.
    When user send a some output(here count =2 by using stored procedure) from server1.
    In server2 user when execuite the stored procedure ,out should be double here 4.
    i think by declaring one in parameter and out parameter.
    But i didn't get.
    how?
    thanks
    kavitha
    __________________
    kavitha
    kavitha
    Reply With Quote Reply With Quote
  2. 06-12-2002, 09:35 AM #2
    bensr
    bensr is offline Member
    Join Date
    Feb 2001
    Posts
    180
    Can you be some more specific?
    Regards
    Ben de Boer
    Reply With Quote Reply With Quote
  3. 06-12-2002, 11:30 AM #3
    Mnemonical
    Mnemonical is offline Senior Member
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282


    create a package and then a variable inside.
    the output should increment this package variable.
    so, whenever an user runs the procedure, the package will make the variable work as a static variable, incrementing it by each procedure call.


    F.
    Reply With Quote Reply With Quote
  4. 06-13-2002, 02:47 AM #4
    kavithared
    kavithared is offline Member
    Join Date
    May 2002
    Posts
    232
    HII,OUT BECOMAE DOUBLE BY USING IN AND OUT PARAMETERS.
    THANKS
    kavitha
    Reply With Quote Reply With Quote
  6. 06-13-2002, 02:55 AM #5
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    paste ur code
    Cheers!
    Cheers!
    OraKid.
    Reply With Quote Reply With Quote
  7. 06-13-2002, 05:15 AM #6
    kavithared
    kavithared is offline Member
    Join Date
    May 2002
    Posts
    232

    procedure

    My, Pmanager need to send some value(like 4) for me through stored procedure,this output become double.
    thanks
    kavitha
    Reply With Quote Reply With Quote
  8. 06-14-2002, 03:06 AM #7
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    can u sen accross the code so that V can give a shot
    Cheers!
    OraKid.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width