Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Component 'PAK_POPL_SUPPL' must be declared error
Top Forums Shell Programming and Scripting Component 'PAK_POPL_SUPPL' must be declared error Post 302575978 by durden_tyler on Wednesday 23rd of November 2011 10:29:05 AM
Old 11-23-2011
Quote:
Originally Posted by csrohit
Hi,

I am using a shell script to run a Oracle procedure in Linux.I am getting the below error while running the procedure:

Code:
ERROR at line 1:
ORA-06550: line 1, column 22:
PLS-00302: component 'PAK_POPL_SUPPL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

SHELL SCRIPT which Iam using is -->

Code:
 
#!/bin/ksh
# File   :  run_package.sh
# --------------------------------------------------
ORACLE_HOME=/opt/oracle/10.2.0
export ORACLE_HOME
PATH=$PATH:/opt/oracle/10.2.0/bin
export PATH
UNAME=dml_prod
PASS=dml_prod
ORACLE_SID=cb22
sqlplus -s $UNAME@$ORACLE_SID/$PASS << !
SET heading off
SET feedback off
echo "Running Package pak_popl_suppl"
EXEC pak_popl_suppl.pr_supplier_update;
#EXEC pak_popl_suppl.pr_supplier_new;
#EXEC pak_popl_suppl.pak_popl_suppl;
!
if [ $? -eq 0 ]
then
   echo "suceess"
   return $?
else
   echo "Fail"
   return $?
fi

ORACLE PROCEDURE which I am using is -->

Code:
 
CREATE OR REPLACE PACKAGE pak_popl_suppl
IS
PROCEDURE pr_supplier_update;
END PAK_POPL_SUPPL;
/
CREATE OR REPLACE PACKAGE BODY pak_popl_suppl
IS
PROCEDURE pr_supplier_update
IS
CURSOR c_new_supplier  IS
SELECT
sps.entity_cd,
sps.supplier_id,
sps.supplier_name,
sps.address_line1 ,
sps.address_line2 ,
sps.address_line3 ,
sps.city ,
sps.post_code ,
sps.state ,
sps.country ,
sps.phone_number ,
sps.currency ,
sps.fax_number ,
sps.email_address
FROM stage_popl_supplier sps
WHERE NOT EXISTS(SELECT *
FROM popl_supplier ps
WHERE sps.entity_cd = ps.entity_cd
AND sps.supplier_id = ps.supplier_id)
AND sps.entity_cd <> '****';    --  exclude the dummy Supplier added Brian Clark 10 Nov 2011
v_count NUMBER :=0;
BEGIN
FOR v_new_supp IN c_new_supplier LOOP
v_count := v_count +1;
INSERT INTO popl_supplier
VALUES
(
v_new_supp.entity_cd,
v_new_supp.supplier_id,
v_new_supp.supplier_name,
v_new_supp.address_line1,
v_new_supp.address_line2,
v_new_supp.address_line3,
v_new_supp.city,
v_new_supp.post_code,
v_new_supp.state,
v_new_supp.country,
v_new_supp.phone_number,
v_new_supp.currency,
v_new_supp.fax_number,
v_new_supp.email_address,
(chappi_popl_supplier.NEXTVAL),
'Y'
);
END LOOP;
Dbms_Output.ENABLE(1000000);
Dbms_Output.put_line(v_count);
COMMIT;
EXCEPTION
 WHEN OTHERS THEN
 ROLLBACK;
Dbms_Output.put_line(SQLCODE ||'-'||SQLERRM);
END pr_supplier_update ;
END PAK_POPL_SUPPL;

Does the database user "dml_prod" have the privilege to execute "pak_popl_suppl" ?

tyler_durden
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Fax Component

I would like to build a small fax component in Java or Perl. I have the javax.comm. (rxtx gnu.io) for Java for serial connection and get send a message to my fax were the light goes on and port is taken, but after that I am in the dark. Does anyone have some reference as to where I can get some... (1 Reply)
Discussion started by: photon
1 Replies

2. Shell Programming and Scripting

accessing variables declared in another perl script

Hi all, I have a perl script which declares two variables and calls another perl script which accesses those variables. But I am unable to access the variables in the called script. My script is as follows: my $ENV{a}="20"; system("perl called.pl"); and my called.pl contains: print... (3 Replies)
Discussion started by: gurukottur
3 Replies

3. Shell Programming and Scripting

shell script: Bind variable not declared

Hi Friends, I am trying to run a sql query from shell script as below but I get "Bind variable "1" not declared" error. 1.sh shell script has following: sDb="abc/xyz@aaa" a="1.sql" sqlplus -s $sDb @$a $1 1.sql file has following: spool Result.tmp append select cust_name from orders... (1 Reply)
Discussion started by: ppat7046
1 Replies

4. AIX

`pthread_rwlock_t' was not declared in this scope

Hello All, I am getting this error while compiling my application on IBM AIX 5.3. As I tried to define _XOPEN_SOURCE=500 in makefile, that didn't work. Please help us to resolve the error. (0 Replies)
Discussion started by: mustus
0 Replies

5. Programming

Locally Declared Labels

Hi guys. in the Locally Declared Labels section in "The Definitive Guide to GCC" book there is block of code: #define SEARCH(array, target) ({ __label__ found; typeof (target) _SEARCH_target = (target); typeof (*(array)) *_SEARCH_array = (array); int i, j; int value;... (1 Reply)
Discussion started by: majid.merkava
1 Replies

6. Shell Programming and Scripting

Help in separating variables declared in the main function

Hi! I've a C program as shown below.. The line numbers and the statements of the program are separated by a space.. 1 #include<stdio.h> 2 char a,b,c; 3 float x,y,z; 4 int main() 5 { 6 int d,e,f; 7 // further declarations 8 // further declarations 9 /* body*/ 10 } 11 void fun1() 12... (1 Reply)
Discussion started by: abk07
1 Replies

7. Shell Programming and Scripting

Assign user input to already declared array

What I am doing is creating a top menu, which a user will select a choice with a number entry. That number corresponds to a string in an array. I then want to assign that response to another array I've already declared. For example: #!/bin/bash colors=(red blue yellow) red=(cherry fire)... (2 Replies)
Discussion started by: Akilleez
2 Replies

8. Shell Programming and Scripting

**URGENT**component 'PAK_POPL_SUPPL' must be declared error

hi, I am using a shell script to run a Oracle procedure in Linux.I am getting the below error while running the procedure: (1 Reply)
Discussion started by: csrohit
1 Replies

9. Shell Programming and Scripting

write in file using printf with variable declared with a phrase

Hi guys, kinda new to unix/linux, could you please help me figure this out. i need to write in a file using printf. printf "%-20s %-40s %-20s\n" $a $b $c >> out.txt but a, b and c are declared in a header file: a='I am a dog' b='I am a cat' c='I am a fish' i want the file to look like... (1 Reply)
Discussion started by: kokoro
1 Replies

10. Shell Programming and Scripting

PHP: declared variables, strlen vs isset

greetings, pretty new to php and i think i might be missing some fundamental limitation of isset. i have two php scripts below that are executed by crond, one using --host X and one that does not. and below that are three different attempts at generating a command line that will be executed. the... (8 Replies)
Discussion started by: crimso
8 Replies

LEARN ABOUT OPENSOLARIS

metarecover

metarecover(1M) 					  System Administration Commands					   metarecover(1M)

NAME

       metarecover - recover soft partition information

SYNOPSIS

       /sbin/metarecover [-n] [-v] [-s setname] component -p

       /sbin/metarecover [-n] [-v] [-s setname] component -p {-d}

       /sbin/metarecover [-n] [-v] [-s setname] component -p {-m}

DESCRIPTION

       The  metarecover  command scans a specified component to look for soft partition configuration information and to regenerate the configura-
       tion.

OPTIONS

       The following options are supported:

       -d	     Recover soft partitions in the metadevice state database from the extent headers on the device. Options -d and -m	are  mutu-
		     ally exclusive.

       -m	     Regenerate  the extent headers and reapplies them to the underlying device based on the soft partitions listed in the metade-
		     vice state database. Options -d and -m are mutually exclusive.

       -n	     Do not actually perform the operation. Show the output or errors that would have resulted from the  operation,  had  it  been
		     run.

       -p	     Regenerate  soft  partitions based on the metadevice state database or extent headers on the underlying device. If neither -d
		     nor -m are specified, this option compares the soft partition information in the metadevice  state  database  to  the  extent
		     headers.

       -s setname    Specify  the  name  of  the diskset on which metarecover works. Using the s option causes the command to perform its function
		     within the specified diskset. Without the -s option, the metarecover command operates on the  metadevices	and/or	hot  spare
		     pools in the local diskset.

		     This option is required to recover former sps from a diskset component or raw-device. setname must be identical to the former
		     setname in which the sps were created. The set numbers, however, seem irrelevant.

       -v	     Verbose mode, displaying the changes being made.

OPERANDS

       The following operand is supported:

       component    Specifies the c*t*d*s* number of the disk or slice containing the partitions, or the device name (for  example,  d10)  of  the
		    metadevice containing the partitions.

		    component can be a slice name, component name, /dev/dsk path, or /dev/rdsk path.

EXAMPLES

       Example 1 Updating Metadevice State Database Based on Disk Extent Headers

       A  disk containing soft partitions is moved from one system to another. The system administrator would like to use the existing soft parti-
       tions. metarecover updates the metadevice state database based on the extent headers on the disk.

	 # metarecover -v c0t3d0s2 -p -d

       Example 2 Updating Metadevice State Database Based on Incomplete Soft Partition Creation

       A system crashes in the middle of creating a new soft partition. The soft partition is in the creating state and the driver  does  not  let
       that device be opened. metarecover rewrites the extent headers for the partially created soft partition and mark it as Okay.

	 # metarecover -v c0t3d0s2 -p -m

       Example 3 Updating Extent Headers Based on Metadevice State Database

       Someone	accidentally  overwrote  a portion of a disk leaving extent headers destroyed. metarecover rewrites the extent headers to ensure a
       valid soft partition configuration, though user data is not recovered.

	 # metarecover -v d5 -m

       The following example implements the same command using a descriptive name.

	 # metarecover -v myvolume -m

       Example 4 Validating Soft Partition Configuration

       To validate the existing soft partition configuration, use metarecover with only the -p flag.

	 # metarecover c0t3d0s2 -p

EXIT STATUS

       The following exit values are returned:

       0     Successful completion.

       >0    An error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWmdr			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Stable			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mdmonitord(1M), metaclear(1M),  metadb(1M),  metadetach(1M),  metahs(1M),  metainit(1M),  metaoffline(1M),  metaonline(1M),  metaparam(1M),
       metarename(1M),	metareplace(1M), metaroot(1M), metaset(1M), metassist(1M), metastat(1M), metasync(1M), metattach(1M), md.tab(4), md.cf(4),
       mddb.cf(4), md.tab(4), attributes(5), md(7D)

SunOS 5.11							    26 Mar 2006 						   metarecover(1M)
All times are GMT -4. The time now is 09:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy