OraFAQ Forum: SQL & PL/SQL » help with some DBMS

Home » SQL & PL/SQL » SQL & PL/SQL » help with some DBMS_SQL Code

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help with some DBMS_SQL Code [message #567]

Thu, 21 February 2002 00:28

Micky
Messages: 18
Registered: January 2002

Junior Member

Hi

Can you please explain the highlighted coding for me. I have marked the specific code with /*-->.

1. Can U explain what DBMS_SQL.NATIVE role in all this is?

create or replace procedure drop_table
(v_table_name IN VARCHAR2)
is
dyn_cur number;
dyn_err varchar2(255);
begin
/*-->dyn_cur:=DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(dyn_cur,'drop table'||v_table_name,/*-->DBMS_SQL.NATIVE);
DBMS_SQL.CLOSE_CURSOR(dyn_cur);
exception
WHEN OTHERS THEN
/*-->dyn_err:=sqlerrm;
/*-->DBMS_SQL.CLOSE_CURSOR(dyn_cur);
RAISE_APPLICATION_ERROR(-20600,/*-->dyn_err);
end drop_table;
/
sho err

Cheers Micky

Report message to a moderator

Re: help with some DBMS_SQL Code [message #569 is a reply to message #567]

Thu, 21 February 2002 07:50

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

give space after 'drop table '

create or replace procedure drop_table
(v_table_name IN VARCHAR2)
is
dyn_cur number;
dyn_err varchar2(255);
begin
dyn_cur:=DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(dyn_cur,'drop table '||v_table_name,DBMS_SQL.NATIVE);
DBMS_SQL.CLOSE_CURSOR(dyn_cur);
exception
WHEN OTHERS THEN
dyn_err:=sqlerrm;
DBMS_SQL.CLOSE_CURSOR(dyn_cur);
RAISE_APPLICATION_ERROR(-20600,dyn_err);
end drop_table;

Report message to a moderator