Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Stored Procedure Question

    How do you test stored procedure that has IN parameters?

    create or replace procedure proc1 (ls_var IN varchar2, ls_var1 IN number, ls_var2 IN number)

    IS

    .............

    Please help. Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SQL> execute proc1 ('var1' , 2, 3) ;
    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
    Jul 2004
    Posts
    268
    Inside my stored procedure I insert the IN parameters into the table. The ls_var parameter should pass the stored procedures name.

    INSERT INTO table1 VALUES (1, ls_var, 87, 4);

    I ran the execute command, but the table doesn't have these values.

  4. #4
    Join Date
    Jul 2004
    Posts
    61
    Hi

    After executing insert command, you should run commit command,
    then data is actually inserted into table.

    Thi Nguyen

  5. #5
    Join Date
    Apr 2004
    Posts
    246
    you don't need a commit to see the data from the same session. Assume you're in sqlplus and you run the proc. If it finishes successfully, you can see the data immed. w/o a commit - you can later commit or rollback. However, another session will not be able to see the data unless it is committed. And, putting a commit into every proc is the dumbest thing possible.
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

Posting Permissions

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