RE: oracle10g

2003-07-21 Thread Baswannappa, Shiva



grid 
computing

Shiva

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 9:59 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  oracle10g
  What 
  on earth does the g stand for? RBG
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, 
MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: 
Multiple recipients of list ORACLE-LSubject: 
oracle10g
Gotta love 
oracle.

It won't be 10i, 
it'll be Oracle10g

what on earth are 
they thinking?

http://www.oracle.com/oracleworld/paris/conference/


How to test whether a text file exists in Dev6i on client machine

2003-07-18 Thread Baswannappa, Shiva



Hi 
Gurus

I need to test 
whether a text file 'a.txt' exists in the default oracle reports directory on 
client machine and print at the end of the report? I can use text_io but I don't 
seem to see a test for file existence. 

Appreciate any help. 
Have a great weekend.


Regards 
Shiva Baswannappa Life 
Sciences Business UnitDigital 
Consulting  Software Services, Inc._ 
Phone: 281.243.2658Fax: 
281.243.2504Web: http://www.dcss.com
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



RE: printing out of Pl/SQL

2003-07-01 Thread Baswannappa, Shiva
Hi Von

If you do not want to have any opportunity to expose any external person or
process to tamper the output file, then I think one way you could achieve it
is by writing a report and run the report and print it directly to the
printer. That would be just a bit of a work but it will meet the
requirements.

THT
Shiva

-Original Message-
Sent: Tuesday, July 01, 2003 2:35 AM
To: Multiple recipients of list ORACLE-L


Hi,

Von: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]
Gesendet am: Montag, 30. Juni 2003 18:09

1. Have the UTL_FILE write to a file in directory called 
'printdir' (you can
name it whatever you like)

.

that is exactly the way it is running right now but our customer
had to change it's mind due to some fiscal policies in his country.

So I have to be more online with my printoutput.

Means, as soon, as the data reaches the database it has to be printed
onto endless paper which is stamped by the finacial office. So nobody
should be able to manipulate the data... preventing tax fraud.

 Frank 




Confidentiality Notes

This email and any files transmitted is intended only for the person or
entity to which it is addressed and may contain confidential and/or
privileged material. If you are not the authorised recipient, any use,
disclosure, copying, distribution or any action taken or omitted to be
taken in reliance on it, is prohibited. If you received this in error,
please contact the sender and delete the material from any computer.

E-mail messages are not necessarily secure. Scheidt  Bachmann does not
accept responsibility for any changes made to this message after it was
sent. 

Thank you for your cooperation!

Diese E-Mail und alle angehängten Dateien ist ausschließlich für die
Person / Personen bestimmt, an die diese adressiert ist und könnte
vertrauliche und / oder rechtlich geschützte Informationen enthalten.
Sollten Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum
Empfang berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede
Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das
Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte
Information untersagt. Sollten Sie diese E-Mail irrtümlich erhalten
haben, benachrichtigen Sie bitte den Absender und löschen diese E-Mail
von jedem Computer.

E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt 
Bachmann übernimmt keine Verantwortung für Veränderungen dieser
Mitteilung, die nach dem Senden vorgenommen wurden. 

Herzlichen Dank für Ihre Unterstützung!


-



-Ursprüngliche Nachricht-
Von: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]
Gesendet am: Montag, 30. Juni 2003 18:09
An: Multiple recipients of list ORACLE-L
Betreff: RE: printing out of Pl/SQL

Hi 

I came across similar situation few months ago. You could do 
following in NT
environment.

1. Have the UTL_FILE write to a file in directory called 
'printdir' (you can
name it whatever you like)
2. Write a NT Shell script to check for any file in 
'printdir'. if there is
one, use 'print filename ' or 'copy xx lpt1:' or any other networked
printer.
3. Once file printing is complete, have the file moved to 
another directory
or delete it from 'printdir'
4. schedule a periodic job scheduler to execute NT shell script.

There are some permission requirements to for the scheduler to 
execute NT
shell script.

First test printing of file from the 'printdir' in command 
shell and then
incorporate same into shell script.

If you prefer, you could use shell command to schedule 
periodic execution of
shell script instead of job scheduler.

HTH

Shiva



-Original Message-
Sent: Monday, June 30, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L


Hi

SPOOL OUT will only write the SQL*plus output to the default printer on
UNIX it is not implemented in SQL*plus for NT. 

You cannot do what you are trying to do below. UTL_FILE can only read
and write clear text files. I am not an expert on windows internals but
lpt1 is a device / port so should be some sort of device driver so i
guess it has a different file type. UTL_FILE probably does a check
internally to test if the file being opened is a text file. your best
bet is to use C to write an external procedure to do it, or 
perhaps pipe
the output from a text file to the printer externally. i.e use utl_file
to write to a file and have a batch job that runs every few minutes and
spools the file to the printer?

hth

kind regards

Pete

-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit 
specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network

RE: printing out of Pl/SQL

2003-06-30 Thread Baswannappa, Shiva
Hi 

I came across similar situation few months ago. You could do following in NT
environment.

1. Have the UTL_FILE write to a file in directory called 'printdir' (you can
name it whatever you like)
2. Write a NT Shell script to check for any file in 'printdir'. if there is
one, use 'print filename ' or 'copy xx lpt1:' or any other networked
printer.
3. Once file printing is complete, have the file moved to another directory
or delete it from 'printdir'
4. schedule a periodic job scheduler to execute NT shell script.

There are some permission requirements to for the scheduler to execute NT
shell script.

First test printing of file from the 'printdir' in command shell and then
incorporate same into shell script.

If you prefer, you could use shell command to schedule periodic execution of
shell script instead of job scheduler.

HTH

Shiva



-Original Message-
Sent: Monday, June 30, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L


Hi

SPOOL OUT will only write the SQL*plus output to the default printer on
UNIX it is not implemented in SQL*plus for NT. 

You cannot do what you are trying to do below. UTL_FILE can only read
and write clear text files. I am not an expert on windows internals but
lpt1 is a device / port so should be some sort of device driver so i
guess it has a different file type. UTL_FILE probably does a check
internally to test if the file being opened is a text file. your best
bet is to use C to write an external procedure to do it, or perhaps pipe
the output from a text file to the printer externally. i.e use utl_file
to write to a file and have a batch job that runs every few minutes and
spools the file to the printer?

hth

kind regards

Pete

-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Tool/Method for migration of Oracle character based reports to De

2003-06-18 Thread Baswannappa, Shiva




Hi 
Gurus

I am looking for a 
tool/method resource to migrate over 100 reports written in Oracle character 
based reporting tool to Developer 6i. Appreciate any help link or any method 
that could speed up this process. There is link on Oracle Metalink that refers 
to forms migration, I am looking for Reports migration. 

Thanks a ton in 
advance
Regards 
Shiva Baswannappa Life 
Sciences Business UnitDigital 
Consulting  Software Services, Inc._ 
Phone: 281.243.2658Fax: 
281.243.2504Web: http://www.dcss.com
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



Testing tools for custom applications developed using 100% Oracle

2003-06-06 Thread Baswannappa, Shiva



Hi All 
Gurus

My division is 
pondering over acquiring automated testing tools for applications and 
customizations made to the existing applications. Development is done using 
almost 100% oracle tools barring O/S scripts in Unix/W2K, external C/C++ 
routines and some automation for instruments. I am looking for automated testing 
tools that support robust oracle development. If you have come across such tools 
or used them or heard about them, I would appreciate some information on 
this.

Thanks in advance 
It's been a very fruitful association and have good weekend

Regards 
Shiva Baswannappa Life 
Sciences Business UnitDigital 
Consulting  Software Services, Inc._ 
Phone: 281.243.2658Fax: 
281.243.2504Web: http://www.dcss.com
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



LOV on Forms 6i to be populated with data from SQL Server 2000 ta

2003-05-30 Thread Baswannappa, Shiva



Hi 
Gurus

I have a unusual 
request from one of new clients. I have an application that is 100% Oracle forms 
6i, and reports 6i and DB 8.1.7 running on W2K platform. Clients wants to know 
whether he can populate aLOV onOracle form with data from one of the 
columns of a table in SQL Server 2000.

Is there a way to 
achieve this with something like database link, dynamic link, 
etc...

Appreciate any help 
or lead or direction to documentation in regard

Thanks in 
advance
Regards 
Shiva Baswannappa Life 
Sciences Business UnitDigital 
Consulting  Software Services, Inc._ 
Phone: 281.243.2658Fax: 
281.243.2504Web: http://www.dcss.com
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



Sending Again: How to identify Report Builder version 6 and 6i

2003-01-31 Thread Baswannappa, Shiva



Hi Folks 


I am sending this 
question again as it is very crucial for me.


Is there a way to 
identify Oracle Report Builder 6 and differentiate it from 
6i?

The version on my PC is 6.0.5.35 is this version considered as 
6i?

It is crucial for me 
since one of the client has report server which has problems running reports 
built using version 6i.

Thanks in 
advance
Regards 
Shiva Baswannappa Senior Developer Digital Consulting and Software Services 
Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com 
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



How to identify Report Builder 6 and 6i

2003-01-30 Thread Baswannappa, Shiva



Hi 
Gurus

Is there a way to 
identify Oracle Report Builder 6 and differentiate it from 
6i?

It is crucial for me 
since one of the client has report server which has problems running reports 
built using version 6.

Thanks in 
advance

Regards 
Shiva Baswannappa Senior Developer Digital Consulting and Software Services 
Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com 
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



Need help and documentation on moving database from Unix to W2K

2003-01-29 Thread Baswannappa, Shiva



Hi 
Gurus

I am not a DBA, 
but I have request from client to move their oracle 8.1.6 database from a 
Unix server to W2K. Can somebody lead me to documentation in moving entire DB or 
any other resource that will help me accomplish the task?

Thanks a ton in 
advance

Regards 
Shiva Baswannappa Senior Developer Digital Consulting and Software Services 
Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com 
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



RE: Need help and documentation on moving database from Unix to W

2003-01-29 Thread Baswannappa, Shiva
Thanks everybody

I have performed it on a smaller test machine and will do the production
database import/export tonight.

Regards

Shiva

-Original Message-
Sent: Wednesday, January 29, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
W


Shiva
First I would suggest you consider whether this is a good use of your
client's money. This is a somewhat complex task that will be a good learning
experience for you personally, but may cost the client. You should also
consider how you will be able to confirm the quality of your work once you
are done. Will you be able to ensure the client will have a robust Oracle
database they can rely on?
   Overall the steps are: 
Install Oracle on Windows.
Create a database, with the same usernames and tablespaces as the
Unix database.
Perform a full export of the data.
Import the data into the Windows database.
Verify that the import was successful and no data was lost.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, January 29, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus
 
I am not a DBA, but  I have request from client to move their oracle 8.1.6
database from a Unix server to W2K. Can somebody lead me to documentation in
moving entire DB or any other resource that will help me accomplish the
task?
 
Thanks a ton in advance
 
Regards 

Shiva Baswannappa 
Senior Developer 
Digital Consulting and Software Services 
Phone: 281.243.2658 
Fax: 281.243.2504 
Web: http://www.dcss.com http://www.dcss.com/  

If the reader of this e-mail is not an intended recipient, you have received
this e-mail in error and any review, dissemination, distribution or copying
is strictly prohibited. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and permanently delete the
copy you received. Thank you.

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




Print command from PLSQL calling java stored procedure does not w

2002-12-10 Thread Baswannappa, Shiva



Gurus

I am still 
struggling to print text files to a network printer. I have tried various 
options to issue a print command through batch file. 

my batch files 
are

test1.bat
print 
/d:\\myprinterserver\myprinter c:\myfolder\myfile.txt

test2.bat
net use lpt1: \\myprintserver\myprinter 

print 
c:\myfolder\myfile.txt

test3.bat
copy 
c:\myfolder\myfile.txt lpt1:

test4.bat
type 
c:\myfolder\myfile.txt \\myprintserver\myprinter

if I add another 
line "copy c:\myfolder\myfile.txt copied.txt" at the beginning to all the above 
batch files, the copy command works but not the print 
command.

I am using oracle 
8.1.7 on W2K. PLSQL procedure calls java stored procedure example of which is 
provided on oracle TechNet docid 165256.1. I have used other examples for JSP. 
they work for all dos shell commands except print. 

Any note, hint is 
appreciated.

Thanks in 
advance

Regards 
Shiva Baswannappa Senior Developer Digital Consulting and Software Services 
Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com 
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



Are There any way of calling NT OS Commands like print, del etc.

2002-12-05 Thread Baswannappa, Shiva




Hi Gurus
I am looking for easy of calling OS commands like print, del, etc. from 
PL/SQL on a NT4 system running Oracle 8.1.7. I tried the Java approach from 
oracle web site, it works for few commands and not all. 
Any insight, direction and help to achieve is very much appreciated.
Thanks in advance
Regards 
Shiva Baswannappa Senior Developer Digital Consulting and Software Services 
Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com 
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.



RE: Toasters

2002-12-04 Thread Baswannappa, Shiva
And

And... if Enron had made toasters...  The toast would have come out crooked,
and later 'magically' shred itself into croutons! 

: Shiva

-Original Message-
Sent: Wednesday, December 04, 2002 3:39 AM
To: Multiple recipients of list ORACLE-L


As a bit of light relief
John



Carry on til the end for the SAP toaster
If IBM made toasters ... They would want one big toaster where people bring
bread to be submitted for overnight toasting. IBM would claim a worldwide
market for five, maybe six toasters. 
If Xerox made toasters ... You could toast one-sided or double-sided.
Successive slices would get lighter and lighter. The toaster would jam your
bread for you. 
If Radio Shack made toasters ... The staff would sell you a toaster, but not
know anything about it. Or you could buy all the parts to build your own
toaster. 
If Oracle made toasters ... They'd claim their toaster was compatible with
all brands and styles of bread, but when you got it home you'd discover the
Bagel Engine was still in development, the Croissant Extension was three
years away, and that indeed the whole appliance was just blowing smoke. 
If Sun made toasters ... The toast would burn often, but you could get a
really good cuppa Java. 
Does DEC still make toasters?... They made good toasters in the '80s, didn't
they? 
If Hewlett-Packard made toasters ... They would market the Reverse Toaster,
which takes in toast and gives you regular bread. 
If Tandem made toasters ... You could make toast 24 hours a day, and if a
piece got burned the toaster would automatically toast you a new one. 
If Thinking Machines made toasters ... You would be able to toast 64,000
pieces of bread at the same time. 
If Cray made toasters ... They would cost $16 million but would be faster
than any other single-slice toaster in the world. 
If the NSA made toasters ... Your toaster would have a secret trap door that
only the NSA could access in case they needed to get at your toast for
reasons of national security. 
If Sony made toasters ... The ToastMan, which would be barely larger than
the single piece of bread it is meant to toast, can be conveniently attached
to your belt. 
If Timex made toasters ... They would be cheap and small quartz-crystal
wrist toasters that take a licking and keep on toasting. 
If Fisher Price made toasters ... Baby's First Toaster would have a
hand-crank that you turn to toast the bread that pops up like a
Jack-in-the-box. 
And, of course: If Microsoft made toasters ... Every time you bought a loaf
of bread, you would have to buy a toaster. You wouldn't have to take the
toaster, but you'd still have to pay for it anyway. Toaster'95 would weigh
15000 pounds (hence requiring a reinforced steel countertop), draw enough
electricity to power a small city, take up 95% of the space in your kitchen,
would claim to be the first toaster that lets you control how light or dark
you want your toast to be, and would secretly interrogate your other
appliances to find out who made them. Everyone would hate Microsoft
toasters, but nonetheless would buy them since most of the good bread only
works with their toasters. 
If Apple made toasters ... It would do everything the Microsoft toaster
does, but 5 years earlier. 
If SAP made toasters, the manual to run the toaster would be approximately
10,000 pages long. The toaster would come with 2,500 switches which would
all have to be set in an exact pattern and in a precise sequence in order to
toast specific kinds of bread. Each pattern would be established by SAP's
experts as the Best Practices method of toasting that kind of bread. It
would take a team of basis and functional contractors about 1 year to
configure the toaster in the best manner, and then another 6 months to test
it. In the mean time, your entire family would need to attend extensive
training classes on how to use the new toaster. In order to support end
users and consultants, MIT would establish a list-serv for people to post
questions and answers regarding toaster set-up and operation. Of course, the
online help would randomly pop up in German. But once it was running, you'd
get the best toast in the world.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538

RE: Utl_file and OPENVMS

2002-10-01 Thread Baswannappa, Shiva
).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Help on Effect of changing NLS_LANGUAGE to maerican_america.utf8

2002-09-25 Thread Baswannappa, Shiva



Hi 
Gurus

We customize 
pharmaceutical processing industry applications. One of our client is going 
global. The client needs to change NLS_LANGUAGE setting to 
NLS_LANG="american_america.utf8". 
I would like 
to know how to change this and 

what impacts 
will it have on reports and forms already custom developed for this client? 


There are some 
barcode checksum calculation procedures for some reports. Willthey get 
impacted by changing the NLS_LANG? 

A input on this is 
highly appreciated

Regards 
Shiva Baswannappa 



RE: Help on Effect of changing NLS_LANGUAGE to maerican_america.u

2002-09-25 Thread Baswannappa, Shiva

Sorry Gurus

The database version is: 8.1.6.0.0
Reports: 6.0.5.28.0
Forms: 6.0.5.2

Current NLS_LANGUAGE: AMERICAN
Current NLS_NCHAR_CHARACTERSET: WE8ISO8859P1
Current NLS_CHARACTERSET: WE8ISO8859P1
Current NLS_CALENDAR: GREGORIAN

Appreciate your response

Shiva



-Original Message-
Sent: Wednesday, September 25, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
maerican_america.utf8



What version of the database?  What version of forms/reports?  What
platform?  What is the current
characterset of the database?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


 

  [EMAIL PROTECTED]

   To:
[EMAIL PROTECTED] 
  09/25/02 10:03 AMcc:

  Please respond toSubject:  Help on Effect of
changing NLS_LANGUAGE to   
  ORACLE-L  maerican_america.utf8

 

 





Hi Gurus

We customize pharmaceutical processing industry applications. One of our
client is going global. The
client needs to change NLS_LANGUAGE setting to
NLS_LANG=american_america.utf8.
I would like to know how to change this and

what impacts will it have on reports and forms already custom developed for
this client?

There are some barcode checksum calculation procedures for some reports.
Will they get impacted by
changing the NLS_LANG?

A input on this is highly appreciated

Regards


Shiva Baswannappa







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



How can I change Oracle as well as NT Domain passwords

2002-09-20 Thread Baswannappa, Shiva

Hi All

How can I change passwords of a user of Oracle application as well as W2K/NT
Login? Any utility in 8/8i can do this form me?

Thanks in Advance

Shiva B
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: How can I change Oracle as well as NT Domain passwords

2002-09-20 Thread Baswannappa, Shiva

Thanks for responding 

I need to change oracle application user's password from within application.
I also need to change same user's W2K/NT domain account password whenever
that user changes their password in oracle application. Hope I am clear
here. 

Appreciate your response 

and Thanks a ton in advance

Shiva B
---

-Original Message-
Sent: Friday, September 20, 2002 4:58 PM
To: Multiple recipients of list ORACLE-L


Are you trying to change the Oracle and NT Domain accounts
which are the same and you want the same password ???
If not,  write a script or request that one be sent to you.


-Original Message-
Sent: Friday, September 20, 2002 10:31 AM
To: Multiple recipients of list ORACLE-L


Hi All

How can I change passwords of a user of Oracle application as well as W2K/NT
Login? Any utility in 8/8i can do this form me?

Thanks in Advance

Shiva B
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson, Michael 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baswannappa, Shiva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Is it possible to use NET 8i client with oracle 6 development too

2002-09-18 Thread Baswannappa, Shiva



Hi Every 
one

I have been 
struggling with installing net8i client with the development tools viz. reports 
builder "Report Builder 6.0.5.28.0", and forms builder "Forms [32 Bit] Version 
6.0.5.0.2 (Production)". I use PLSQL Developer from all round automation as an 
aid to development. Their new version 5.0.1.480 provides facility to handle 
nested objects which we use extensively. This tool works great when I use with 
oracle 8i development tools, but crashes when I access nested objects 
usingnet 8 client.

My environment has 
to be developer 6 tools as all my business clients have developer 6 in 
controlled environment. 

I would appreciate 
if someone could provide insight into installing net8i client to work with 
developer 6 tools ORprovide steps to upgrade net8 client to net8i 
client

Many thanks in 
advance

Regards 
Shiva Baswannappa