473,396 Members | 1,683 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

set serverout on problum

hi all,

i made a simple package before executing the package i make set servrout on.

but next time when again i compile and execute the package again.

I again need to do set serverout on.

this is very irritating can any body help me

thanks.
Dec 5 '07 #1
2 1617
debasisdas
8,127 Expert 4TB
Serverout is an environmental variable.
The value exists for the current session only.
So setting serverout to ON is temporary.
Dec 6 '07 #2
thanks for u r reply

i think environment variable become disable when we broke and reconnect to the
server but here connection is maintained.

so why this is happening.

if it then how to make it on every time i recompile the package.

thanks
Dec 6 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: george lewycky | last post by:
I am trying to take a field description for a column of about 200+ bytes and wrap the field into 3 lines of 70 bytes apiece in PL/SQL!!!!!! I know this can be done in SQL*Plus as show below but...
19
by: nitro_punk85 | last post by:
I'm working on a project for my c++ class and I am having trouble comparing one string to two others using the or operator. It looks something like this: if(answer3 == answer1 || answer2) Is...
4
by: newlearner | last post by:
Hi, I wrote a socket program to pass message form client and server. This is a test case and to be inplemented in the later stage. In my test case the connection between the server and the...
1
by: shruthimr | last post by:
Hello, I have written a java stored procedure to execute an exe file, which works fine when compiled.The class code is given below. create or replace and resolve java source named...
5
Inbaraj
by: Inbaraj | last post by:
Hi.. I hava a set of records in Dataset. I want to check the duplicate values which is present in the dataset. Plz help me with sample code.. thanks in advance... reg Inba
1
by: umesh049 | last post by:
hi DELETE FROM orders WHERE order_id = :id;
5
by: umesh049 | last post by:
Hello, I want to delete all the date of all the table in a scheman. but i got error at execute immediate statement. can any body help me. thanks
2
by: Lokerin | last post by:
ok here is my problum i have been trying to kick this line of code around for 3 days. i know the problum is staring me in the face i am working on xp office 2007 DoCmd.OpenReport "Report A",...
3
by: moorcroft | last post by:
Hi I am trying to write some sql to because we have a missing foregin key constraint. The following is what I have been asked to do: 1. COMPULSORY_WORK.reference to LISTED_BUILDING.reference ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.