Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    42

    Unanswered: execute stored procedure

    Hi,

    i have a small problem with stored procedrues, i could not execute a procedure from sql prompt, can you tell me what is the exact way to execute a procedure from sql prompt.

    thank you

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    sql> execute procedurename(anyparameters_to_pass);

    HTH
    Gregg

  3. #3
    Join Date
    Dec 2003
    Posts
    42

    execution of stored procedure

    hi, thanks for your reply, here in my procedure iam passing parameter as out parameters and getting values into those parameters

    CREATE OR REPLACE PROCEDURE evaluate ( appowner out varchar2,
    url out varchar2,ipaddress out varchar2)
    is
    hostname ias_servers.host_name%TYPE;
    ip_address ias_servers.ip_address%TYPE;
    os_owner ias_servers.os_owner%TYPE;
    begin
    url := null;
    appowner := null;
    hostname := null;
    ipaddress1 := null;

    SELECT sys_context('USERENV','HOST') INTO hostname
    FROM dual;
    SELECT sys_context('USERENV','IP_ADDRESS') INTO ipaddress1
    FROM dual;
    SELECT sys_context('USERENV','OS_USER') INTO osowner
    from dual;

    SELECT url, app_owner, ip_address INTO v_url, v_app_owner, v_ip_addr
    FROM ias_servers
    WHERE host_name = v_hostname
    AND ip_address = v_ip_address
    AND os_owner = v_os_owner;
    exception
    when NO_DATA_FOUND
    then
    v_url := null;
    v_app_owner := null;
    end;
    /


    just tell me how can i pass the out parameters also

Posting Permissions

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