06-06-2007
Murad,
this is an error in your sql code and is not related to a problem with Sun Solaris. I think you have posted this in a wrong forum. The place to turn to is a Oracle forum.
I can try to give you some hints on the SQL code even do this is not in the scope of this forum. You could post it to this forum and I will have a look. In the future I think it is better to turn to
http://otn.oracle.com or some other place where there are a lot more people discussing Oracle PL/SQL.
For now, what I can see is that you have a ORA-01733 error message, most likely, looking at this error code, you are trying to insert, update or delete something in a view. This is not allowed. Instead of modifying the data in the view you should modify the data in the parent tables of the view.
Regards,
Johan Louwers.
Quote:
Originally Posted by murad.jaber
dears
kindly i give this error when i load package in solaris to oracle db
SQL> @ typfc_pb.sql
Warning: Package Body created with compilation errors.
SQL> show error
Errors for PACKAGE BODY TYPFC_P:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1394/1 PL/SQL: SQL Statement ignored
1400/6 PL/SQL: ORA-01733: virtual column not allowed here
SQL>
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi ,
I want to create a package with the help of rpm command.
command:/usr/lib/rpm/rpmb -bb -v ./pogo.spec >> ./pogo_rpm
1.pogo.spec file contains all the package information along with what files and directories are required for the package
2.pogo_rpm is the file which contains the build and... (0 Replies)
Discussion started by: Rasmita
0 Replies
2. Linux
have following package installed
rpm -qa |grep ADMIN
It will give the following package installed:
ADMIN-4.0.0.1
Now I will upgrade the ADMIN package using the following command.
rpm --upgrade ADMIN-4.1.0.1
It will upgrade the ADMIN packagge to ADMIN-4.1.0.1
Now I want that... (0 Replies)
Discussion started by: amitpansuria
0 Replies
3. Shell Programming and Scripting
My sh scripts is :
sqlplus -S "user/pwd@server" <<!!
SET SQLPROMPT
exec IN_PROC_TEST;
!!
It prompt 'PL/SQL procedure successfully completed.' but not execute actually :mad:
I run this procedure in sqlplus, no problem
and I also could execute simple DDL in this sh script, but why... (2 Replies)
Discussion started by: andrewknight
2 Replies
4. Solaris
hi all,
i have installed gcc-3.4.6-sol10-sparc-local package on unix system.
i tried removing this with the command pkgrm but getting the below error..
pkgrm gcc-3.4.6-sol10-sparc-local
pkgrm: ERROR: no package associated with <gcc-3.4.6-sol10-sparc-local>
can any one suggest me how... (2 Replies)
Discussion started by: ani_rvce
2 Replies
5. UNIX for Advanced & Expert Users
Friends,
Please let meknow, How we can find the dependancies of .dstream package & .rpm package before installation ?
For AIX, We can use the inutoc . command to create the .toc file for the bff package, What about Solaris & Linux ? (0 Replies)
Discussion started by: yb4779
0 Replies
6. UNIX for Advanced & Expert Users
Hi,
I have installed gmake 3.82 in my aix 5.3 system.
but while installing a package,after doing./configure ,i give gmake and its throwing below error.
# gmake
"build/Makefile.rules", line 13: make: 1254-055 Dependency line needs colon or double colon operator.
also the command is not... (1 Reply)
Discussion started by: sonal kumar
1 Replies
7. UNIX for Dummies Questions & Answers
Hello,
i have downloaded an rpm package "hadoop-0.20.205.0-1.amd64.rpm"
in /usr/local/ directory.
I'm trying to install the rpm package in a new path/location (/usr/local/hadoop-0.20.205), but i can't.
I did:
1st try: Didn't work
sudo rpm -i --prefix=/usr/local/hadoop-0.20.205... (1 Reply)
Discussion started by: g_p
1 Replies
8. Emergency UNIX and Linux Support
Hello,
i have installed a package by using the command
sudo rpm -i filepackage.rpm
package filepackage is already installed
when i try to remove it, i get an error saying "is not installed":
sudo rpm -e filepackage.rpm
error: package filepackage is not installed
How can... (4 Replies)
Discussion started by: g_p
4 Replies
9. Ubuntu
Hi, everytime I do "sudo apt-get " and install package or just upgrade I get the following error:
sha256sum mismatch jdk-7u3-linux-x64.tar.gz
Oracle JDK 7 is NOT installed.
dpkg: error processing oracle-java7-installer (--configure):
subprocess installed post-installation script returned... (1 Reply)
Discussion started by: programAngel
1 Replies
LEARN ABOUT DEBIAN
sql::statement::term
SQL::Statement::Term(3pm) User Contributed Perl Documentation SQL::Statement::Term(3pm)
NAME
SQL::Statement::Term - base class for all terms
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::Term->new( $owner );
# access the value of that term
$term->value( $eval );
DESCRIPTION
SQL::Statement::Term is an abstract base class providing the interface for all terms.
INHERITANCE
SQL::Statement::Term
METHODS
new
Instantiates new term and stores a weak reference to the owner.
value
Abstract method which will return the value of the term. Must be overridden by derived classes.
DESTROY
Destroys the term and undefines the weak reference to the owner.
NAME
SQL::Statement::ConstantTerm - term for constant values
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::ConstantTerm->new( $owner, 'foo' );
# access the value of that term - returns 'foo'
$term->value( $eval );
DESCRIPTION
SQL::Statement::ConstantTerm implements a term which will always return the same constant value.
INHERITANCE
SQL::Statement::ConstantTerm
ISA SQL::Statement::Term
METHODS
new
Instantiates new term and stores the constant to deliver and a weak reference to the owner.
value
Returns the specified constant.
NAME
SQL::Statement::ColumnValue - term for column values
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::ColumnValue->new( $owner, 'id' );
# access the value of that term - returns the value of the column 'id'
# of the currently active row in $eval
$term->value( $eval );
DESCRIPTION
SQL::Statement::ColumnValue implements a term which will return the specified column of the active row.
INHERITANCE
SQL::Statement::ColumnValue
ISA SQL::Statement::Term
METHODS
new
Instantiates new term and stores the column name to deliver and a weak reference to the owner.
value
Returns the specified column value.
AUTHOR AND COPYRIGHT
Copyright (c) 2009,2010 by Jens Rehsack: rehsackATcpan.org
All rights reserved.
You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
README file.
perl v5.10.1 2011-02-01 SQL::Statement::Term(3pm)