Shulou(Shulou.com)06/01 Report--

I.

Create or replace procedure Drop_DbLink (schemaName varchar2, dbLink varchar2) is

Plsql varchar2 (1000)

Cur number

Uid number

Rc number

Begin

Select u.user_id into uid from dba_users u

Where u.username = schemaName

Plsql: = 'drop database link "' | | dbLink | |'"'

Cur: = SYS.DBMS_SYS_SQL.open_cursor

SYS.DBMS_SYS_SQL.parse_as_user (

C = > cur

Statement = > plsql

Language_flag = > DBMS_SQL.native

UserID = > uid

);

Rc: = SYS.DBMS_SYS_SQL.execute (cur)

SYS.DBMS_SYS_SQL.close_cursor (cur)

End

/

II.

SQL > exec Drop_DbLink ('WFG_ADMIN','DBLINKWFG')

3.

SQL > drop procedure Drop_DbLink

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.