Sponsored Content
Full Discussion: package error
Operating Systems Solaris package error Post 302120398 by suntac on Wednesday 6th of June 2007 09:59:15 AM
Old 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

package error

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

how to restore original package after uninstalling the upgraded package using rpm

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

invoke oracle package error?

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

error in removing the package

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

How to find dependancies of .dstream package (Solaris) & .rpm package( linux)

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

Make giving error after configuring a package

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

Can't install rpm package with --prefix in new path.Error: package is not relocatable

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

Problem when trying to remove a package using rpm command - error: package is not installed

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

java error during upgrade or installation of package

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
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)
All times are GMT -4. The time now is 08:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy