Re: Dynamic Database Link in Stored Function

You must use dynamic SQL , in Oracle server package DBMS_SQL

Ng TC napisa³(a) w wiadomo¶ci:
<01bd8f63$3bf220a0$ebce2aca_at_mis1-235.yas.com.sg>...
>
>Hi,
>
>I have a simple function that takes in 2 parameters:
>
> FUNCTION GET_SET_OF_BOOKS_ID(COMP VARCHAR2, DB_LINK VARCHAR2)RETURN
>NUMBER;
...
>
>If I do the following, the stored procedure would not compile/save.
>
> FROM hr_organization_units_v_at_DB_LINK hou,
>
>
>How do I achieve this dynamic database link in the select statement?
>
>Please advise.
>
>Thanks,
>Tse Chong
Received on Thu Jun 04 1998 - 09:08:07 CEST