03-27-2007
Quote:
Originally Posted by ganapati
no luck, result is same
/export/home/ITC_rlok>cat a.log
Errored while inserting to the table aaa BEGIN a.log a.sh a.sql CR11 CRED0001 RMIS SLLD0005 TEMP TEST ERROR at line 1: ORA-01722: invalid number ORA-06512: at line 6
Any other option please?
Try this:
sqlplus -s user/password@database @a.sql 1>>a.log 2>&1
Also, make sure you "zero" your a.log first and try fresh.
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I'm getting an error - symbol referencing errors. No output written to, etc
Can anybody tell me why this is? (2 Replies)
Discussion started by: Dan Rooney
2 Replies
2. Solaris
Both of these messages are filling up the /var/adm/messages files on these two Sun boxes, goober and gomer. The print server is called gold.
Jul 31 03:15:40 gold bsd-gw: request to ma28084.Solaris (unknown printer) from goober
Jul 31 03:16:39 gold bsd-gw: request to ma28084.Solaris (unknown... (1 Reply)
Discussion started by: antalexi
1 Replies
3. AIX
When I try to list a directory that I have been using rsync to copy, I now am getting the following message.
root # ls -alt /directory
ls: /directory: Value too large to be stored in data type.
total 0
I can change directory and list the contents of directories within /directory, but I... (2 Replies)
Discussion started by: sallender
2 Replies
4. UNIX for Advanced & Expert Users
I get this error message as soon as i log in
-bash: /usr/local/software/.../vni/CTT6.0/ctt/bin/lopt64.sh: No such file or directory
I looked into the etc/profile but there are no lines sourcing this file.
And there is no lopt64.sh in the directory vni/.../bin
I couldn't fogure out what... (4 Replies)
Discussion started by: dsmv
4 Replies
5. Shell Programming and Scripting
I am new to scripting.
I am using the following script . BART.dat contains the string 'Y' .
#!/bin/ksh
cd /work/TCI/data_out
file=`cat BART.dat`
echo "$file"
if ; then
echo "true"
fi
When i am executing the above script i am getting the following error
./s.ksh: : not found
... (2 Replies)
Discussion started by: ammu
2 Replies
6. UNIX for Dummies Questions & Answers
I keep getting an error message in a script im writing, this line is allways pointed out.
if
and this is the message i keep getting.
line 32: [: 8: unary operator expected
Whats wrong with it?
Please Help. (5 Replies)
Discussion started by: chapmana
5 Replies
7. UNIX for Dummies Questions & Answers
I was reviewing logs and I got this error message in /var/log/messages:
Did not receive identification string from (IP ADDRESS)
What does it mean? (6 Replies)
Discussion started by: mojoman
6 Replies
8. UNIX for Dummies Questions & Answers
Hi I found the following error message in my logs:
warning: /etc/hosts.deny, line 6: can't verify hostname: getaddrinfo(localhost) didn't return ::ffff:222.255.28.33
What is the error message trying to indicate? That there is a problem with line 6 (2 Replies)
Discussion started by: mojoman
2 Replies
9. Red Hat
Hello,
while i was saving a web file directing on to usb location there was some network problem which result in error WRITE DELAYED on windows xp.
so pen drive is not getting completely formated(show as Windows was unable to complete format).From then onwords it is not allowing to copy... (0 Replies)
Discussion started by: amarnathbasis8
0 Replies
LEARN ABOUT DEBIAN
sql::translator::parser::sqlite
SQL::Translator::Parser::SQLite(3pm) User Contributed Perl Documentation SQL::Translator::Parser::SQLite(3pm)
NAME
SQL::Translator::Parser::SQLite - parser for SQLite
SYNOPSIS
use SQL::Translator;
use SQL::Translator::Parser::SQLite;
my $translator = SQL::Translator->new;
$translator->parser("SQL::Translator::Parser::SQLite");
DESCRIPTION
This is a grammar for parsing CREATE statements for SQLite as described here:
http://www.sqlite.org/lang.html
CREATE INDEX
sql-statement ::=
CREATE [TEMP | TEMPORARY] [UNIQUE] INDEX index-name
ON [database-name .] table-name ( column-name [, column-name]* )
[ ON CONFLICT conflict-algorithm ]
column-name ::=
name [ ASC | DESC ]
CREATE TABLE
sql-command ::=
CREATE [TEMP | TEMPORARY] TABLE table-name (
column-def [, column-def]*
[, constraint]*
)
sql-command ::=
CREATE [TEMP | TEMPORARY] TABLE table-name AS select-statement
column-def ::=
name [type] [[CONSTRAINT name] column-constraint]*
type ::=
typename |
typename ( number ) |
typename ( number , number )
column-constraint ::=
NOT NULL [ conflict-clause ] |
PRIMARY KEY [sort-order] [ conflict-clause ] |
UNIQUE [ conflict-clause ] |
CHECK ( expr ) [ conflict-clause ] |
DEFAULT value
constraint ::=
PRIMARY KEY ( name [, name]* ) [ conflict-clause ]|
UNIQUE ( name [, name]* ) [ conflict-clause ] |
CHECK ( expr ) [ conflict-clause ]
conflict-clause ::=
ON CONFLICT conflict-algorithm
CREATE TRIGGER
sql-statement ::=
CREATE [TEMP | TEMPORARY] TRIGGER trigger-name [ BEFORE | AFTER ]
database-event ON [database-name .] table-name
trigger-action
sql-statement ::=
CREATE [TEMP | TEMPORARY] TRIGGER trigger-name INSTEAD OF
database-event ON [database-name .] view-name
trigger-action
database-event ::=
DELETE |
INSERT |
UPDATE |
UPDATE OF column-list
trigger-action ::=
[ FOR EACH ROW | FOR EACH STATEMENT ] [ WHEN expression ]
BEGIN
trigger-step ; [ trigger-step ; ]*
END
trigger-step ::=
update-statement | insert-statement |
delete-statement | select-statement
CREATE VIEW
sql-command ::=
CREATE [TEMP | TEMPORARY] VIEW view-name AS select-statement
ON CONFLICT clause
conflict-clause ::=
ON CONFLICT conflict-algorithm
conflict-algorithm ::=
ROLLBACK | ABORT | FAIL | IGNORE | REPLACE
expression
expr ::=
expr binary-op expr |
expr like-op expr |
unary-op expr |
( expr ) |
column-name |
table-name . column-name |
database-name . table-name . column-name |
literal-value |
function-name ( expr-list | * ) |
expr (+) |
expr ISNULL |
expr NOTNULL |
expr [NOT] BETWEEN expr AND expr |
expr [NOT] IN ( value-list ) |
expr [NOT] IN ( select-statement ) |
( select-statement ) |
CASE [expr] ( WHEN expr THEN expr )+ [ELSE expr] END
like-op::=
LIKE | GLOB | NOT LIKE | NOT GLOB
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
SEE ALSO
perl(1), Parse::RecDescent, SQL::Translator::Schema.
perl v5.14.2 2012-01-18 SQL::Translator::Parser::SQLite(3pm)