| Setting DBMS_OUTPUT limit per user [message #52287] |
Fri, 12 July 2002 04:58  |
Steve Boreham
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
One of my customers using an Oracle 8i database has written a bolt-on to the application that I support, and which makes use of DBMS_OUTPUT.
Although I am not oblidged to support this malarky, they have asked an interesting question of an Oracle nature, that I don't know the answer to, but would like to!
Somehow, somewhere, DBMS_OUTPUT is being defaulted to 100,000 bytes, but this is often insufficient for the bolt on modification to work.
My customer therefore wishes to set the default DBMS_OUTPUT value for the users who run the bolt-on, and nobody else, to the ceiling of 1,000,000 bytes.
Can this be done, please, by setting certain Oracle priviledges for the users in question?
Grateful thanks,
Steve
|
|
|
|
| Re: Setting DBMS_OUTPUT limit per user [message #52295 is a reply to message #52287] |
Fri, 12 July 2002 08:06  |
Radek
Messages: 33
Registered: April 2002
|
Member |
|
|
hi,
dbms_output.enable(_number_of_bytes_) will do the trick. They have to do it before calling procedure that is outputting data.
Something like this:
begin
dbms_output.enable(1000000);
their_package.their_procedure();
end;
Regards,
Radek
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
