I have a procedure that uses database link but I need to use it with database link and also without database link.
Could you help me improve pl/sql?
CREATE OR REPLACE PROCEDURE PRC_DBLINK
IS
v_oder NUMBER;
SELECT dh.order INTO v_order
FROM document@dbl_history dh
WHERE rownum <= 1
dbms_output.put_line('records: ' || v_order)
end PRC_DBLINK;
Thanks a lot.