Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    4

    Unanswered: dropping functions

    Bonjour,

    I'm as green as can be....and I created a function but could not drop it when
    things went south.....

    create or replace function available(client_id, property_id)
    return number
    is
    ret number := 0;
    begin
    begin
    select nvl2(c.client_id,1,0)
    into ret
    from client c, property p
    where p.property_id = property
    and p.asking_price <= c.max_rent(+)
    and c.client_id (+) = client;
    exception
    when no_data_found then
    ret := 0;
    end;
    return ret;
    end;
    /



  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Did you try:
    Code:
    DROP FUNCTION AVAILABLE;

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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