OraFAQ Forum: Performance Tuning » Exec DMBS

Home » RDBMS Server » Performance Tuning » Exec DMBS_STATS Visual Basic

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

Exec DMBS_STATS Visual Basic [message #65389]

Sun, 05 September 2004 06:01

gurinder
Messages: 16
Registered: September 2004

Junior Member

how to call DBMS_Stats,DBMS_UTIL package from visual basic
Gurinder

Report message to a moderator

Re: Exec DMBS_STATS Visual Basic [message #65395 is a reply to message #65389]

Tue, 07 September 2004 16:55

andrew again
Messages: 2577
Registered: March 2000

Senior Member

It's just a built-in package - you can call it the same way as you'd call your own PL/SQL pkg/proc/function.

Report message to a moderator

Re: Exec DMBS_STATS Visual Basic [message #65463 is a reply to message #65395]

Sat, 25 September 2004 05:00

gurinder
Messages: 16
Registered: September 2004

Junior Member

Sir
It is right but when i call the procedure which has Exec DBMS_STATS then that procedure give me error invalid SQL statement. The user from i am calling has all the DBA rights.
Thanx Gurinder

Report message to a moderator

Previous Topic:	Perfectly tuning a Query
Next Topic:	Regarding cost and Card

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 08 03:52:33 CDT 2025