| dbms_sql.parse [message #37451] |
Fri, 08 February 2002 02:38  |
lakshmi
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
Hi All,
I am not able to execute the DBMS_SQL.PARSE(ID,STRING,DBMS_SQL.NATIVE)..
I am not getting any errors..Can anyone help me in this..
Thanks,
Lakshmi.
|
|
|
|
| Re: dbms_sql.parse [message #37452 is a reply to message #37451] |
Fri, 08 February 2002 06:49  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
hi,
you must be doing something wrong.please explain little bit more.it is better idea to post your code.
here is an example which analyze all the objects in the current schema.you can refer to this
set serveroutput on
DECLARE
CURSOR_ID INTEGER;
NUMROWS INTEGER;
CURSOR REGRANT_CUR IS
SELECT 'ANALYZE TABLE '||TABLE_NAME ||' ESTIMATE STATISTICS ' GRANTCOMMAND
FROM USER_TABLES;
V_COMMAND VARCHAR2(400);
BEGIN
CURSOR_ID := DBMS_SQL.OPEN_CURSOR;
FOR TMP_CUR IN REGRANT_CUR
LOOP
BEGIN
V_COMMAND :=TMP_CUR.GRANTCOMMAND;
DBMS_SQL.PARSE(CURSOR_ID,V_COMMAND,DBMS_SQL.NATIVE);
NUMROWS:=DBMS_SQL.EXECUTE(CURSOR_ID);
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
END LOOP;
DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM);
DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
END;
/
cheers
pratap
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
