| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: ORA-24323
I tried backslashes but this also failed.
I don;t have login.sql and other concerned files in my directory from where
i am running the scripts.
This script is running fine in other databases. This database is created
with UTF8 characterset.
I don;t think that characcter set will be the problem.
Vinay
-----Original Message-----
Walthour
Sent: Tuesday, July 17, 2001 8:12 PM
To: Multiple recipients of list ORACLE-L
Vinay:
While Remco is correct here (about using backslashes), that was probably just an oversight on your part in writing the email. Are you running or do you have a login.sql or glogin.sql script in your SQLPATH directory or the current working directory? If so, try removing it or unsetting your SQLPATH environment variable.
-- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, OhioReceived on Tue Jul 17 2001 - 22:58:11 CDT
>--- Original Message ---
>From: "Daemen, Remco" <R.Daemen_at_facent.nl>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 7/17/01 10:06:16 AM
>
>How about trying c:\mypath\mysql.sql ? Note the backslashes
instead of the
>forward slashes !
>
>Tip: start the day with lots of coffee ... :)
>
>-----Oorspronkelijk bericht-----
>Van: vsharma_at_alletec.com [mailto:vsharma_at_alletec.com]
>Verzonden: dinsdag 17 juli 2001 15:51
>Aan: Multiple recipients of list ORACLE-L
>Onderwerp: ORA-24323
>
>
>Hello All.
>
>When i am running my sql script from SQL/PLUS command using
>@C:/mypath/mysql.sql
>giving error
>
>ORA-24323: value not allowed
>Error accessing package DBMS_APPLICATION_INFO, and disconnected
the user
>from the database .
>Second time when i reconnect and run the script again it runs
successfully.
>
>I have nearly 150 such scripts to be run and i can not use batch
sql file to
>run these scripts as it generally fails after one script.
>
>Can some one help me that what is wrong with my databse. Why
ORA-24323 error
>is coming.
>
>Thanks in advance
>Vinay
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: vsharma_at_alletec.com
>
>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: ListGuru_at_fatcity.com (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: Daemen, Remco
> INET: R.Daemen_at_facent.nl
>
>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: ListGuru_at_fatcity.com (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: Jon Walthour INET: jonw_at_fuse.net 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: ListGuru_at_fatcity.com (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: INET: vsharma_at_alletec.com 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: ListGuru_at_fatcity.com (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).
 |
 |