Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
analyze from forms
- Thread starter lelo25
- Start date
Hi,
FORMS_DDL will not work.
Make a Stored procedure with following code & call it in your form.
Procedure xxx (P_TNAME VARCHAR2,P_ERROR VARCHAR2)IS
a varchar2(1000):='ANALYZE TABLE '||TNAME||' COMPUTE STATISTICS ';
BEGIN
EXECUTE IMMEDIATE A;
P_ERROR :='SUCCESS';
EXCEPTION
WHEN OTHERS THEN
P_ERROR :=SQLERRM;
END;
Regards
Himanshu
FORMS_DDL will not work.
Make a Stored procedure with following code & call it in your form.
Procedure xxx (P_TNAME VARCHAR2,P_ERROR VARCHAR2)IS
a varchar2(1000):='ANALYZE TABLE '||TNAME||' COMPUTE STATISTICS ';
BEGIN
EXECUTE IMMEDIATE A;
P_ERROR :='SUCCESS';
EXCEPTION
WHEN OTHERS THEN
P_ERROR :=SQLERRM;
END;
Regards
Himanshu
- Status
Similar threads
- Locked
- Question
- Locked
- Question