RE: Oracle 9iAS form displays gray box

[Randy Pace]

This appears to be standard appearance. The 
browser is not trying to display anything else. All you have done after you 
press the OK is close the form. After forms closes it simply keeps the gray box 
there.

  -Original 
  Message-From: John Shaw 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, September 11, 
  2003 8:49 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: Oracle 9iAS form displays gray 
  boxJust a guess - but you might need to create / configure a 
  provider for forms - also you might check your display setting in the conf 
  file.>>> [EMAIL PROTECTED] 9/10/2003 4:49:29 PM 
  >>>
      
  Hi 
      
      
      
      
      
      
      
    NT 
  2000   
    Oracle 
  9.0.2.0.1  
    Oracle 9ias 
  9.0.2.0.1 
      
    Installed infrastructure and tested 
  ok    
    Installed middle tier and tested 
  ok   
      
    When I was testing the forms services from demo tab to test running 
  the     demo 
  form 
    it shows form services installed successfully. When I hit ok it is 
  trying   to load 
  another   
    form but all I get is a gray 
  box. 
      
    I also tried this on my local machine where I have 9i dev installed 
  to      test with another form and I get a gray 
  box.  
    Jinitiator and OC4J listener are running on local to test 9i 
  development    
  install   
    Any one have any 
  suggestions. 
      
      
      
  Thanks 
      
  Rick-- Please see the official 
  ORACLE-L FAQ: http://www.orafaq.net-- 
  Author:   INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California    -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).

RE: Ora 29540 error

[Randy Pace]

We were finally able to get this redone. 

Thank you so much for your help.

Randy R. Pace
Development Team Leader

Accela, Inc. 
9662 South 700 East
Sandy
UT, 84070

Tel: 801 495 9300 
Fax: 801 495 9301

www.accela.com  <http://www.accela.com>



-Original Message-
Sent: Wednesday, December 04, 2002 1:27 PM
To: Multiple recipients of list ORACLE-L


Randy,

I don't think the JVM is missing.

try installing the $ORACLE_HOME/plsql/jlib/plsql.jar file using sqlloader.
the class files from this file are what are missing.

hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 04, 2002 2:10 PM
To: Multiple recipients of list ORACLE-L



Install the JVM...see MetaLink Note:156477.1

Jeff Herrick

On Wed, 4 Dec 2002, Randy Pace wrote:

>
> I get the following when trying to use the utl_tcp package on 8.1.7
> database.
>
>
> The following error has occurred:
>
> ORA-29540: class oracle/plsql/net/TCPConnection does not exist
> ORA-06512: at "SYS.UTL_TCP", line 537
> ORA-06512: at "SYS.UTL_TCP", line 199
> ORA-06512: at "SYS.UTL_SMTP", line 102
> ORA-06512: at "SYS.UTL_SMTP", line 121
> ORA-06512: at "KIVA.RP_SEND_MAIL", line 51
> ORA-06512: at line 5
>
> What is missing from the database in order for that to run?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  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: Mercadante, Thomas F
  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: Randy Pace
  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).

tkprof on 901 database

[Randy Pace]

I have a 9.01 database installed on my laptop and cannot find the
tkprof.exe. Has it been renamed or is it part of an installation that I did
not do?

Thanks for any and all replys.

Randy R. Pace
Development Team Leader

Accela, Inc. 
9662 South 700 East
Sandy
UT, 84070

Tel: 801 495 9300 
Fax: 801 495 9301

www.accela.com  <http://www.accela.com>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Randy Pace
  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).

Ora 29540 error

[Randy Pace]

Title: Ora 29540 error






I get the following when trying to use the utl_tcp package on 8.1.7 database.



The following error has occurred:


ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at "SYS.UTL_TCP", line 537
ORA-06512: at "SYS.UTL_TCP", line 199
ORA-06512: at "SYS.UTL_SMTP", line 102
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "KIVA.RP_SEND_MAIL", line 51
ORA-06512: at line 5


What is missing from the database in order for that to run?


Thanks for any help.
Randy R. Pace
Development Team Leader

Accela, Inc.
9662 South 700 East
Sandy
UT, 84070

Tel: 801 495 9300
Fax: 801 495 9301

www.accela.com  

Re: awk, sed, windoze, sql*loader, other fun stuff

[Randy Pace]

Title: awk, sed, windoze, sql*loader, other fun stuff



One site that has the main Unix tools is http://virtunix.itribe.net/.
 
I have them and use them all the time.
 
 
Randy Pace Phone 801 495 9300 9662 S 700 E 
  Fax 801 495 9301 Sandy, Utah 84070 
   email [EMAIL PROTECTED]

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, August 29, 2001 12:26 
  PM
  Subject: awk, sed, windoze, sql*loader, 
  other fun stuff
  
  Hello all, 
  I'm working on sql*loader scripts and I 
  realize that I'd probably be DONE by now if I had awk and sed to use.  Of 
  course, as unix-deficient as I am, I don't have it.  Does anyone know of 
  a windows version of these utilities?  
  Also I seem to remember someone had 
  created a dynamic create-control-file-based-on-a-table script in the past and 
  shared it with the list.  Does anyone remember where that was?  
  
  Gracias 
  Lisa Koivu The Bootylicious DBA Ft. Lauderdale, FL, USA 

Re: TOAD v/s PL/SQL Developer

[Randy Pace]

We have been using free TOAD for over a year and have gotten from them
somehow an extenstion of the expire license to not expire for the next 5
years. This version of TOAD meets our needs so we see no reason to upgrade
for most of us.


Randy Pace Phone 801 495 9300
9662 S 700 E   Fax 801 495 9301
Sandy, Utah 84070email [EMAIL PROTECTED]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 1:38 PM


> Folks,
>  Just got an e-mail from my Damager that there is a concern about the cost
> of TOAD licensees and an effort is being made to find a suitable
> replacement. Evaluation of PL/SQL Developer by Allround Automations is
> underway. Anyone knows the pros/cons of using this (PL/SQL Developer)
> product in place of TOAD. We have been TOADing since it used to be a
> freeware.
> All and any comments welcome..
> Thanks
>
> Regards,
> - Kirti Deshpande
>   Verizon Information Services
>http://www.superpages.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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: Randy Pace
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Problem with import

[Randy Pace]

I have a database 8.1.7 personal and had a client send me an export . When I
try the import I get the message

ORA-01874: time zone hour must be between -12 and 13.

I have never run across this before. What can I do to resolve the issue?

Thanks for you help.


Randy Pace Phone 801 495 9300
9662 S 700 E   Fax 801 495 9301
Sandy, Utah 84070email [EMAIL PROTECTED]


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).