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

Thread: passing parameters

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    Hi,

    Is it possible that whicle executing the procedure.in between i ask the user to enter some value and then proceed..
    like passing parameter at runtime ....from the user?

    Thanx in advance

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Can you give an example of your code?
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Like that?
    select count(*) from &table_name;

  4. #4
    Join Date
    Jun 2001
    Posts
    316
    something like this


    create or replace procedure test123(val in varchar2) as
    begin
    dbmsoutput.....(val);
    now i want to ask the user:
    press 1 to delte all the tables
    press 2 to del all the triggers
    press 3 to delete all the procedures
    press 4 to delte everything
    andn when the user presses a number
    its processed....

    well is it possible or...................



    AM I WATCHING STAR TRECK A LITTLE TOO MUCH!!!!!!!!

  5. #5
    Join Date
    Jun 2001
    Posts
    316
    select count(*) from &table_name;


    can i use something like this in procedures?

Posting Permissions

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


Click Here to Expand Forum to Full Width