06-06-2007
package error
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::translator::schema::procedure
SQL::Translator::Schema::Procedure(3pm) User Contributed Perl Documentation SQL::Translator::Schema::Procedure(3pm)
NAME
SQL::Translator::Schema::Procedure - SQL::Translator procedure object
SYNOPSIS
use SQL::Translator::Schema::Procedure;
my $procedure = SQL::Translator::Schema::Procedure->new(
name => 'foo',
sql => 'CREATE PROC foo AS SELECT * FROM bar',
parameters => 'foo,bar',
owner => 'nomar',
comments => 'blah blah blah',
schema => $schema,
);
DESCRIPTION
"SQL::Translator::Schema::Procedure" is a class for dealing with stored procedures (and possibly other pieces of nameable SQL code?).
METHODS
new
Object constructor.
my $schema = SQL::Translator::Schema::Procedure->new;
parameters
Gets and set the parameters of the stored procedure.
$procedure->parameters('id');
$procedure->parameters('id', 'name');
$procedure->parameters( 'id, name' );
$procedure->parameters( [ 'id', 'name' ] );
$procedure->parameters( qw[ id name ] );
my @parameters = $procedure->parameters;
name
Get or set the procedure's name.
$procedure->name('foo');
my $name = $procedure->name;
sql
Get or set the procedure's SQL.
$procedure->sql('select * from foo');
my $sql = $procedure->sql;
order
Get or set the order of the procedure.
$procedure->order( 3 );
my $order = $procedure->order;
owner
Get or set the owner of the procedure.
$procedure->owner('nomar');
my $sql = $procedure->owner;
comments
Get or set the comments on a procedure.
$procedure->comments('foo');
$procedure->comments('bar');
print join( ', ', $procedure->comments ); # prints "foo, bar"
schema
Get or set the procedures's schema object.
$procedure->schema( $schema );
my $schema = $procedure->schema;
equals
Determines if this procedure is the same as another
my $isIdentical = $procedure1->equals( $procedure2 );
AUTHORS
Ken Youens-Clark <kclark@cshl.org>, Paul Harrington <Paul-Harrington@deshaw.com>.
perl v5.14.2 2012-01-18 SQL::Translator::Schema::Procedure(3pm)