Can you help me
I have problem in ORACLE 10G RELASE 1 running in windows 2000 server

ORA-12549 TNS: OPERATING SYSTEM RESOURCE QUOTA EXCEEDED

How to solve it and how to acquire more OS resource


Best Regards
Khalid Ihmidan
IT - Manager
Shared Services - IT Division
SARCO- SHAMEL- OCP- GENSERV
Tel:      +968 244 90 473 – Ext (101)  
Fax:     +968 244 90 463
Mobile: +968 994 21 566
Email: [Email address protected]


-----Original Message-----
From: siva [mailto:oracledba-ezmlmshield-x15695781.[Email address protected]
Sent: Monday, December 31, 2007 11:38 AM
To: LazyDBA Discussion
Subject: RE: length overflow DBMS_OUTPUT



You can increase your DBMS_OUTPUT package length and
if you want execute you package or procedure use like this in SQL prompt

begin
DBMS_OUTPUT.ENABLE(100000);
package_name.procedure_name(parameters list);
end;
/


Regards,
Siva.P
Bangalore

________________________________

From: Pravin Subramanian [mailto:oracledba-ezmlmshield-x17643206.[Email
address protected]
Sent: Fri 12/28/2007 5:42 PM
To: LazyDBA Discussion
Subject: RE: length overflow DBMS_OUTPUT



Dear Shadab,

Try using this statement

execute dbms_output.enable(2000000)

Where the argument to enable() is the buffer size you need.

Regards,

Pravin

-----Original Message-----
From: Shadab Mehboob
[mailto:oracledba-ezmlmshield-x20806821.[Email address protected]
Sent: Friday, December 28, 2007 5:29 PM
To: LazyDBA Discussion
Subject: length overflow DBMS_OUTPUT

Dear Masters
I have an error wheni display the output and the error message is as shown
below

ERROR at line 1:
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 99
ORA-06512: at "SYS.DBMS_OUTPUT", line 65
ORA-06512: at line 337


How do i increase the limit beyond 255 .
Kindly help
Regards
Shadab


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html








---
This e-mail message may contain confidential, proprietary or legally
privileged information. It should not be used by anyone who is not the
original intended recipient.If you have erroneously received this message,
please delete it immediately and notify the sender. The recipient
acknowledges that 3i Infotech or its subsidiaries and associated companies,
(collectively "3i Infotech"), are unable to exercise control or ensure or
guarantee the integrity of/over the contents of the information contained in
e-mail transmissions and further acknowledges that any views expressed in
this message are those of the individual sender and no binding nature of the
message shall be implied or assumed unless the sender does so expressly with
due authority of 3i Infotech. Before opening any attachments please check
them for viruses and defects.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






***********************
No virus was detected in the attachment no filename
No virus was detected in the attachment no filename

Your mail has been scanned by InterScan.
***********-***********


****************************************************************************
****************************************************************************
*************
"This message and any attachments are solely for the intended recipient and
may contain Birlasoft confidential or privileged information. If you are not
the intended recipient,any disclosure,copying, use, or distribution of the
information included in this message and any attachments is
prohibited. If you have received this communication in error, please notify
us by reply e-mail at ([Email address protected] and permanently delete this
message and any attachments. Thank you."
****************************************************************************
****************************************************************************
*************


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page