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::reservedwords::oracle
SQL::ReservedWords::Oracle(3pm) User Contributed Perl Documentation SQL::ReservedWords::Oracle(3pm)
NAME
SQL::ReservedWords::Oracle - Reserved SQL words by Oracle
SYNOPSIS
if ( SQL::ReservedWords::Oracle->is_reserved( $word ) ) {
print "$word is a reserved Oracle word!";
}
DESCRIPTION
Determine if words are reserved by Oracle Database.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either Oracle7, Oracle8i, Oracle9i or Oracle10g.
is_reserved_by_oracle7( $word )
Returns a boolean indicating if $word is reserved by Oracle7.
is_reserved_by_oracle8( $word )
Returns a boolean indicating if $word is reserved by Oracle8i.
is_reserved_by_oracle9( $word )
Returns a boolean indicating if $word is reserved by Oracle9i.
is_reserved_by_oracle10( $word )
Returns a boolean indicating if $word is reserved by Oracle10g.
reserved_by( $word )
Returns a list with Oracle versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_oracle7
is_reserved_by_oracle8
is_reserved_by_oracle9
is_reserved_by_oracle10
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://www.oracle.com/technology/documentation/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::Oracle(3pm)