1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how can i get same value in return?

Discussion in 'SQL PL/SQL' started by Ch1bZ, Jul 20, 2010.

  1. Ch1bZ

    Ch1bZ Guest

    i have some problem from converting firebird to oracle

    select count(*)
    into v_is_allowed
    from view_downline(v_agen_id)
    where cust_id=v_id_downline and akun_parent=v_agen_id;

    i know that oracle can't select parameter from procedure.
    but what should i do to get same value from syntax above?

    P.S. view_downline(v_agen_id) is a procedure
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Prabably you may want to try with Inline views in Oracle .

    Inline Views

    And if you still want to use in the same format,
    still you have an option called Pipelined table Functions.

    PileLined table Functions