Home » SQL & PL/SQL » SQL & PL/SQL » DBMS ERROR LOG giving error,plz help
DBMS ERROR LOG giving error,plz help [message #205410] Fri, 24 November 2006 10:14 Go to next message
deepakal
Messages: 2
Registered: November 2006
Junior Member
create or replace package DBMS_ERRLOG
IS
procedure CREATE_ERROR_LOG(dml_table_name in varchar2); end DBMS_ERRLOG;

CREATE OR REPLACE PACKAGE BODY DBMS_ERRLOG IS PROCEDURE CREATE_ERROR_LOG(dml_table_name in varchar2) BEGIN
DBMS_ERRLOG.CREATE_ERROR_LOG(dml_table_name=>'dummy')
END CREATE_ERROR_LOG;
END DBMS_ERRLOG;

please tell me why im getting error for this package execution..whats wrong plz help ASAP

[Updated on: Fri, 24 November 2006 10:18]

Report message to a moderator

Re: DBMS ERROR LOG giving error,plz help [message #205413 is a reply to message #205410] Fri, 24 November 2006 10:27 Go to previous messageGo to next message
gbarbisan
Messages: 67
Registered: August 2006
Location: Treviso - Italy
Member
You are creating a procedure within your package and you are also trying to call the same procedure within the procedure itself.

CREATE OR REPLACE PACKAGE DBMS_ERRLOG IS

  PROCEDURE CREATE_ERROR_LOG(dml_table_name IN VARCHAR2);

END DBMS_ERRLOG;


And

CREATE OR REPLACE PACKAGE BODY DBMS_ERRLOG IS

  PROCEDURE CREATE_ERROR_LOG(dml_table_name IN VARCHAR2) IS
  BEGIN
    (* Do whatever you want here... *)
  END CREATE_ERROR_LOG;

END DBMS_ERRLOG;


[Updated on: Fri, 24 November 2006 10:27]

Report message to a moderator

Re: DBMS ERROR LOG giving error,plz help [message #205414 is a reply to message #205413] Fri, 24 November 2006 10:34 Go to previous messageGo to next message
deepakal
Messages: 2
Registered: November 2006
Junior Member
yeah i got it so how can i execute

[B]BEGIN
     DBMS_ERRLOG.CREATE_ERROR_LOG('dummy');
END[/B] thru a procedure call 


coz im getting error while executing the above query


Thanks in advance

[Updated on: Fri, 24 November 2006 10:38]

Report message to a moderator

Re: DBMS ERROR LOG giving error,plz help [message #205422 is a reply to message #205414] Fri, 24 November 2006 11:48 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You are getting an error? What error? I can't see any ./fa/1659/0/
Previous Topic: eliminate fat tails
Next Topic: grants
Goto Forum:
  


Current Time: Thu Dec 08 18:32:35 CST 2016

Total time taken to generate the page: 0.12174 seconds