Home > Error Accessing > Error Accessing Package Dbms_application_info 10g

Error Accessing Package Dbms_application_info 10g

Contents

Regards Michel Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: ERROR: ORA-06553: PLS-801: internal error [56319] RSS feed Google Youdao Xian Guo Zhua Xia My Yahoo! try { String e2eMetrics[] = new String[OracleConnection.END_TO_END_STATE_INDEX_MAX]; e2eMetrics[OracleConnection.END_TO_END_ACTION_INDEX] = "Starting"; e2eMetrics[OracleConnection.END_TO_END_MODULE_INDEX] = "MyProgram"; e2eMetrics[OracleConnection.END_TO_END_CLIENTID_INDEX] = "tim_hall"; ((OracleConnection) conn).setEndToEndMetrics(e2eMetrics, (short) 0); } catch (SQLException sqle) { // Do something... } Before releasing Kavsek 15950 6 P. More about the author

The problem was fixed. No trackbacks yet. Usage Notes The action name should be descriptive text about the current action being performed. Reply With Quote 04-22-04,13:50 #7 midget View Profile View Forum Posts Visit Homepage Registered User Join Date Mar 2003 Location SJ, Costa Rica Posts 48 well, despite I already figure out http://www.dbforums.com/showthread.php?995294-error-accessing-package-quot-DBMS_APPLICATION_INFO-quot

Error Accessing Package Dbms_application_info Solution

but the issue is when i'm connecting to user it's throwing error... "ERROR: ORA-06553: PLS-801: internal error [56319] Error accessing package DBMS_APPLICATION_INFO " but it's connecting to the specific user and To start viewing messages, select the forum that you want to visit from the selection below. Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: ERROR: ORA-06553: PLS-801: internal error [56319] Error accessing DECLARE v_rindex PLS_INTEGER; v_slno PLS_INTEGER; v_totalwork NUMBER; v_sofar NUMBER; v_obj PLS_INTEGER; BEGIN v_rindex := DBMS_APPLICATION_INFO.set_session_longops_nohint; v_sofar := 0; v_totalwork := 10; WHILE v_sofar < 10 LOOP -- Do some work DBMS_LOCK.sleep(5);

Regards Michel ... You can find it here. You may have to register before you can post: click the register link above to proceed. If you want complete details on Oracle Troubleshooting, I published a book on it:http://www.rampant-books.com/book_2003_1_perf.htm -------------------- Hope this helps. . .

They should ALL be (re)compiled. Error Accessing Package Dbms_application_info 11g If you want to gather your own statistics based on module, you can implement a wrapper around this package by writing a version of this package in another schema that first target_desc Specifies the description of the object being manipulated in this long operation. news krishna kongara Apr 26, 2013, 11:46 ?????

It appears as the UNITS field of v$session_longops. Forgot your password? How to change Solaris10 Hostname? Reply With Quote 04-22-04,13:01 #3 midget View Profile View Forum Posts Visit Homepage Registered User Join Date Mar 2003 Location SJ, Costa Rica Posts 48 where can I find this note?

Error Accessing Package Dbms_application_info 11g

Relinked procedural option (mk -f ins_rdbms.mk procopt) and install (mk -f ins_rdbms.mk install). http://dbaforums.org/oracle/index.php?showtopic=12066 If not the new executable would not have been copied to $ORACLE_HOME/bin Reply With Quote 03-03-05,15:47 #9 midget View Profile View Forum Posts Visit Homepage Registered User Join Date Mar 2003 Error Accessing Package Dbms_application_info Solution regards, Reply With Quote 04-22-04,13:04 #4 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Good judgement comes from experience.

It might be the case that some PL/SQL code has been ran while the database was mounted that forced Oracle to do a dictionary lookup for DBMS_STANDARD which failed and the my review here The DBMSAPIN.SQL script is already run by catproc. who is "you"? And that is it.

It is useful to adding a little more context to the action, as shown in the example below. The reason for this behavior is Bug#2365821 described in Metalink Note 296235.1. You will have to drop these packages and rerun catproc as SYS. 3) Try running "catalog.sql" and "catproc.sql" while opening a spool file to catch any errors that may have occurred. http://axishost.net/error-accessing/error-accessing-package-dbms-application-info-ora-06550.php Boles 14400 8 M.

But this case is bit strange that while running catproc.sql, database is getting terminated. SQL trace, 10046, trcsess and tkprof in Oracle DBMS_SESSION : Managing Sessions From a Connection Pool in Oracle Databases SET_MODULE Once a program makes a connection to the database it should Syntax DBMS_APPLICATION_INFO.READ_MODULE ( module_name OUT VARCHAR2, action_name OUT VARCHAR2); Parameters Table 14-3 READ_MODULE Procedure Parameters Parameter Description module_name Last value that the module name was set to by calling SET_MODULE.

For most folks, they don't know, what they don't know.

This is a view that is used to indicate the on-going progress of a long running operation. Michel Cadot Apr 26, 2013, 12:25 dat's why i said better try to learn reading inst...... Rerun CATPROC.SQL. 2. BEGIN DBMS_APPLICATION_INFO.set_module(module_name => 'add_order', action_name => 'insert into orders'); -- Do insert into ORDERS table.

How do I set ORACLE Environment Variable ► October (8) ► September (6) ► August (3) ► 2008 (3) ► November (1) ► August (1) ► July (1) There was an For storing secured application attributes, you can use the application context feature. Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud navigate to this website No idea what causes it, no clue as to what to do should you encounter it!

Regards Michel Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: ERROR: ORA-06553: PLS-801: internal error [56319] Do the following: 1) Check the status of the package STANDARD using: connect sys/ SQL> SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS' AND OBJECT_NAME = 'STANDARD'; If you find the The AWR Report includes the module in all the reported SQL statistics. regards, -eduardo s.m.

Experience comes from bad judgement. Reply Pingback: Log Buffer #134: A Carnival of the Vanities for DBAs ~ Leave a Reply Cancel reply Enter your comment here... The maximum length is 32 bytes. Results 1 to 2 of 2 Thread: Error while Logging into SQL Plus Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to

Leave a Reply Cancel reply Enter your comment here... Rerun DBMSUTIL.SQL. 3. Enter password: ERROR: ORA-06554: package DBMS_STANDARD must be created before using PL/SQL ERROR: ORA-06554: package DBMS_STANDARD must be created before using PL/SQL Error accessing package DBMS_APPLICATION_INFO Now lets flush the shared Report message to a moderator Re: Error accessing package dbms_application_info [message #323273 is a reply to message #323238] Wed, 28 May 2008 00:43 debajyoti Messages: 5Registered: April 2007

Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are It appears as the OPNAME column of v$session_longops. i Did the Same thing and...... Enter password: ERROR: ORA-06554: package DBMS_STANDARD must be created before using PL/SQL ERROR: ORA-06554: package DBMS_STANDARD must be created before using PL/SQL Error accessing package DBMS_APPLICATION_INFO This standby was providing the

Example This example performs a task on 10 objects in a loop.