SQL & PL/SQL :: SP2-0042 / Unknown Command UNION - Rest Of Line Ignored

Aug 4, 2010

I am getting the error in the text file like

SP2-0042: unknown command "UNION" - rest of line ignored.

I am getting this error in between 300 and 350.

This is my SQL script

WHENEVER SQLERROR EXIT SQL.SQLCODE;
WHENEVER OSERROR EXIT SQL.OSCODE;
set serveroutput on
set newpage 0
set space 0
set pagesize 0
set echo off
set feedback off

[code]....

View 8 Replies


ADVERTISEMENT

SQL & PL/SQL :: Run Command And Connection In One Line

Dec 5, 2011

I want run sql connection and command in one line , something like this ...

sqlplus "/as sysdba" 'select * from dual'

is it possible to do it in one command ?

View 3 Replies View Related

Sqlplus And MS Windows Command Line

Feb 18, 2013

I have some Oracle Databases and sometimes for me is easier to access to the databases with SQLPLUS instead SQLDEVELOPER or TOAD.

But i can't reach to a good configuration of command line prompt to do queries against the database, normaly if it returns a lot o rows and columns it is unreadable.

View 5 Replies View Related

Execute Command Line Program Within Java?

Jan 10, 2012

I've created a Java class in my Oracle DB that calls a Visual Basic program to convert a XLS file into a CSV file in order to load it into an external table. The problem that I have is that when I call the Visual Basic program from the Java class, nothing happens. I had the same problem with a Python program, and I thought that the problem was from Python, but now with Visual Basic the problem remains, both aren't executed.

The strange thing is that when I call the same Java class outside Oracle, directly from a command line, it executes both Python and Visual Basic programs.

Here is the Java class defined in Oracle:

CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "OSCommand" AS
import java.io.*;
public class OSCommand{
public static void Run(){
try
{

[code]....

And here is the procedure that calls the Java class:

create or replace
procedure run_os_command
as language java
name 'OSCommand.Run()';

View 1 Replies View Related

Server Utilities :: ROWS Command Line Parameter

Jan 11, 2013

I am new to SQL*loader and I would like to know what is the maximum number of ROWS that can be loaded in a Conventional bind array while specifying the command line parameter.

View 2 Replies View Related

Server Utilities :: Run DBCA From Unix Command Line?

Aug 27, 2007

i am trying to run DBCA from unix command line. but it gives me error like this:

dbca[158]: /home/oracle/product/10.2.0/jdk/jre/bin/java: not found.

Also i tried to open some other utilites too. like netca it gives me same error.

View 5 Replies View Related

Connect Using Mysql Command Line - Null Password Given

Feb 22, 2010

When I try to connect using the mysql command line, I keep getting an error, I type this exactly:

SQL > Connect
Enter user-name: system
Enter password: (left blank b/c i can't type anything there)
and when I press enter I get the error, null password given, login denied.

View 2 Replies View Related

How To Do DDL Sync On Windows Machine Through Command Line Prompt

Mar 26, 2013

We have siebel server on windows machine and db server on unix box. We have done some modification(added columns) in siebel tools level. Now we want to ddl synch through command line prompt. how ot do ddl sync?

View 4 Replies View Related

Real Application Clusters :: How To Find VIP From Command Line

Oct 1, 2013

find VIP in RAC from command line.

View 2 Replies View Related

PL/SQL :: Write In Sql Command Line Display CUSTOMER Number?

Sep 13, 2013

how to write this in sql command lineDisplay CUSTOMER number, name, rep, balance, and credit limit for all CUSTOMERs of Rep 20. 

In addition, display this information for CUSTOMERs of rep 65 who have a $10,000 credit limit.  Arrange the output by credit limit descending within rep ascending. no more than two decimal digits

View 3 Replies View Related

Client Tools :: How To Open PL/SQL Developer With SQL WINDOW From Command Line

Sep 11, 2013

I am trying to run PL/SQL Developer from command line, So it can open with an opened SQL WINDOW by default, with a script (which I specify in the command ) already in it:

I've tried:

"C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb

but it just opens the application with a connection, no file.

*CORRECTION* While I was writing this post, I tried something , which is not so sophisticated, and it appeared to work...

C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb "C:Program Files (x86)PLSQL Developerandrey.sql"

View 1 Replies View Related

Client Tools :: Changing DB Password Using SQLPlus Command Line

Jul 21, 2010

I'm trying to change a password. I can connect to the db then at the SQL prompt I'm using:

alter user <name> identified by <new password>

The dos window comes back with '2' - then just sits there

View 4 Replies View Related

Client Tools :: Running CodeXpert Through Command Line Using Toad 9.0

Oct 20, 2010

I need to run Toad codexpert using command line I am trying the following command

"C:Program Files... oad.exe" CX="C:... CmdLineTest.ini"

When I execte the command from command line .Codeexprt run and stop after some time and it make entry in the error log as "ora-00942 table or view does not exist".

View 1 Replies View Related

SQL Plus Command Line - Arrow Keys Not Giving Previous Commands Back

Mar 28, 2007

I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the prompt when I use the up and down arrow keys on my keyboard. This is quite easy when I am using a shell, but here with this Oracle command line interface it is not working at all. Here is the example as what actually is happening whe I press the up or down arrow keys.

SQL> drop table mailorders;

Table dropped.

SQL> ^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A

View 2 Replies View Related

Client Tools :: Create Shortcut On Desktop To Have SQLPLUS (command Line)

Sep 6, 2010

The way to create a short cut on desktop to have an sql*plus (command line).

i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, username and password)

View 7 Replies View Related

Server Utilities :: SQL LOADER - Format Of Error Returned By Command Line

Apr 5, 2011

I'm working with sqlldr and i try to insert data from a csv file to a CTL file. One field of my table contains 5 characters but one row has 6 characters in this field, so it's rejected by oracle. (Logical, you can't insert 6 chars in a 5 chars field)

an error is visibly returned, so i wondered how you could catch the value of this error?is it a code? a message?

I'd like to add to my script a condition so that the end of the script would continue even if this error code is returned for that CTL execution.

View 11 Replies View Related

Application Express :: Installation (or Upgrade) Supporting Objects On Command Line

Mar 31, 2013

is it currently possible to install the supporting objects using sqlplus?

When I export an APEX application which contains supporting objects (scripts to install images, css files, tables and seed data) I can run this script on the command line using sqlplus to install the application into the target environment.

After installing the application (which works fine), I cannot invoke the installation of the supporting objects nor the upgrade of the the supporting objects.

Am I overlooking the obvious, have checked APEX_APPLICATION_INSTALL but there is no function available for that purpose?

View 0 Replies View Related

Exadata :: Monitoring Cell Server With OS Watcher / Other Command Line Tools

Aug 7, 2012

we can't use the Exadata Plugin for Cloud Control but we need some monitoring of the Cell Servers.Does OS Watcher is the right tool or do we need ADRCI for incidents and so on.

What do have to install and what information do we get.

View 5 Replies View Related

Reports & Discoverer :: Error Message When Passing The Report Parameter From Command Line?

Jan 31, 2012

I prepared a report in Oracle reports and trying to run the report through command line by creating a batch file. but i am getting the following error message when i run the batch file

REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output

the batch file is as follows

D:DevSuiteHome_1BINRWRUN p:spannawazeitspanna_wa_zeit.Rep userid=alrayatec/alrayatecprod@alraya.world
DESFORMAT=HTMLCSS DESTYPE='mail' DESNAME='sarfraz_it@hnd.com'

View 1 Replies View Related

Client Tools :: Command Line Tools

Jan 22, 2011

I usually work in oracle using the different editors like toad, plsql developer etc. I felt command line is good utility because of various supporting points. I am not sure what kind of command line tools is available/used. I am using pretty straight command line
(run->cmd, then enter username and password).

The best command line tools available. What is generally used command line tools.

View 1 Replies View Related

SQL & PL/SQL :: How To Take Sign Off And Rest Field Value Of First Row For Same Staff

Feb 22, 2013

The below query is taken from the procedure

SELECT l_stafnum = stafnum,
category,
duty,
date,
signon,
signoff,
l_rest = rest,
valid,
FROM SESSION.valid_pf
WHERE invalid != 'I'

In the above query has set of data which each staff may have more than one duty.

For example

stafnum categoy duty date signon signoff rest valid
232 M a/c 2/3/12 5:00 8:00 12:00 I
232 M Sup 2/3/12 10:00 13:00 8:00 I
111 M Clen 2/3/12 9:00 12:00 12:00 I
232 M Sw 2/3/12 15:00 20:00 12:00 I
111 M Wp 2/3/12 10:00 14:00 06:00 I
121 M a/c 2/3/12 5:00 8:00 12:00 I

The select query will retrieve the value which mentioned this example.Now, First I need to take how many duty has been allocated for each stafnumber.

232 staff allocated to three duty (a/c,sup,sw) Then need to compare signoff value for first row addition of rest value for the same row i.e, i = 08:00+1200

Then need to compare value of signon for the same staff 232 for the second row which is 10:00 if (i>10:00) then valid;

how I can take same staff number and find it how many duty the staff has.And how to take sign off and rest field value of first row, for the same staff then compare those value with the same staff number second row signon value.

View 7 Replies View Related

Spatial :: Convert Multi-line To Simple Line

Feb 13, 2013

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

We are processing spatial data from another source to display in our GIS environment. The data is a set of multi lines. The gtype is 2006. A typical geometry looks like:

SDO_GTYPE     2006
SDO_SRID      31370
SDO_POINT.X   NULL     
SDO_POINT.Y   NULL
SDO_POINT.Z   NULL
SDO_ELEM_INFO (1,2,1, 7,2,1)
SDO_ORDINATES (105094.84, 195084.96,
105094.54, 195080.22,
105094.84, 195084.96,
105094.84, 195084.96,
105094.68, 195082.47 )

Now, this is not an actual multiline... it's just encoded as a multi line, but if you look at the coordinates you'll see that the end point of the first line is the same as the beginning of the second line (105094.84, 195084.96).

A better way to encode this geometry would be:

SDO_GTYPE     2002 <---
SDO_SRID      31370
SDO_POINT.X   NULL     
SDO_POINT.Y   NULL
SDO_POINT.Z   NULL
SDO_ELEM_INFO (1,2,1)
SDO_ORDINATES (105094.84, 195084.96,
105094.54, 195080.22,
105094.84, 195084.96, <---
105094.68, 195082.47 )

Is there a standard function in Oracle that does this conversion for me? Or do I have to write my own :)

View 4 Replies View Related

SQL & PL/SQL :: Is It Better To Use UNION (or) UNION ALL With DISTINCT

Apr 22, 2010

Is it better to use UNION (or) UNION ALL with DISTINCT,Which one will improve performance.

Query1:

SELECT deptno FROM emp
UNION
SELECT deptno FROM dept

Query2:

SELECT DISTINCT * FROM(SELECT deptno FROM emp
UNION ALL
SELECT deptno FROM dept)

I mean to say query1 is better (or) query2 is better,which query improves the performance.

View 1 Replies View Related

SQL & PL/SQL :: Primary Constraint On Table Affecting Procedure To Insert Rest Of Rows In Table?

Jun 12, 2012

primary key constraint on transaction_dtl_bk is affecting the insertion of next correct rows.

CREATE OR REPLACE PROCEDURE NP_DB.san_po_nt_wnpg_1 (
dt DATE
)
IS
v_sql_error VARCHAR2 (100); -- added by sanjiv
v_sqlcode VARCHAR2 (100); ---- added by sanjiv added by sanjiv

[code]...

View 2 Replies View Related

Security :: Oracle 11G And Advanced Security / FIPS 140-2 Compliant Encrypt Data At Rest

Dec 26, 2012

Any documentation supporting Oracle 11G and Advanced Security stating encryption at rest is FIPS 140-2 compliant?

View 3 Replies View Related

SQL & PL/SQL :: Ora-12705 - Invalid Or Unknown NLS Parameter Value Specified

Aug 12, 2003

while i log on to the oracel, i get the following error "Ora-12705 - Invalid or unknown NLS parameter value specified" AND i could not log on. how can i rectify this problem?

View 7 Replies View Related

SQL & PL/SQL :: ORA-12705 / Invalid Or Unknown NLS Parameter Value Specified

Sep 7, 2010

I am facing problem with my application while it tries to connect to the Oracle 9i DB using OCI, it fails with ORA-12705: invalid or unknown NLS parameter value specified.

On my client side, the oracle ennvironment variable for the NLS are

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=american_america.we8iso8859p9

same is on the RDBMS side.

SQL> show parameter NLS_LANG

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string AMERICAN

When i try to do a manual connect with sqlplus, it succeeds

$sqlplus /nolog
SQL> connect oltpgen/oltpgen@TSTPOOL
Connected.

I have tried 'unsetting' the NLS_LANG parameter on the client side but did not work.

View 7 Replies View Related

OEM / Unknown Encryption / Data Integrity Algorithm?

Jul 2, 2010

We are attempting to configure/use OEM (Oracle 10.2.0.4) on Solaris, and when logging in to OEM we are directed to the Database Down page, stating Enterprise Manager is unable to connect to the database instance, but showing all the components as up/open. After checking the log, I found the following error:

IO exception: Unknown Encryption or Data Integrity algorithm

I checked the settings in emoms.properties and compared the encryption parameters to those in our SQLNet file, and all match up. We are NOT using Grid Control, just db control connecting to 1 instance.

View 9 Replies View Related

Networking And Gateways :: What Does Status UNKNOWN Mean For A Service

May 26, 2010

I get this error when I try to connect to this database service as another user. I can connect to it as sys without any problem and the database is up.

And when I check to see whether the listener is running for that service, using lsnrctl status command, it shows that the service is UNKNOWN. What does this status mean?

> sqlplus usera/password@prod
SQL*Plus: Release 9.2.0.5.0 - Production on Tue May 25 14:50:35 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect

descriptor

/home/oracle> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 25-MAY-2010 22:56:22
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xxx)(Port=1521))
STATUS of the LISTENER

[code]....

View 8 Replies View Related

Backup & Recovery :: LRM-00101 - Unknown Parameter Name Partition_options

Sep 1, 2013

When I am trying to take backup with partition_options=merge parameter I am getting following error.

Quote:
C:Windowssystem32>expdp system/xxxx directory=mydumps_dir dumpfile=backupdb_01Sep13.dmp tables=abc.dir_transm partition_options=merge logfile=expfdp.log

Error message.

LRM-00101: unknown parameter name 'partition_options'

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved