invoke oracle package error?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting invoke oracle package error?
# 1  
Old 07-29-2008
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 Smilie

I run this procedure in sqlplus, no problem
and I also could execute simple DDL in this sh script, but why could not execute this procedure in sh?

Thanks a lot!
# 2  
Old 07-29-2008
oh!

on problem run this in sqlplus locally
however,after logon remote server and run this in sqlplus, also prompt ''PL/SQL procedure successfully completed',but no run actually
# 3  
Old 07-29-2008
Error Prompt:
SQL> BEGIN
2 EXEC IN_PROC_TEST;
3 END;
4 /
EXEC IN_PROC_TEST;
*
ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00103: Encountered the symbol "IN_PROC_TEST" when expecting one of the
following:
:= . ( @ % ;
The symbol ":=" was substituted for "IN_PROC_TEST" to continue.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

To invoke pass parameters in Oracle file

Hi Guys, I am having a sql script file which does below operations ALTER TABLE M1 EXCHANGE PARTITION FOR (TO_DATE('&1','dd-MON-yyyy')) WITH TABLE &2 INCLUDING INDEXES; i need to pass variables in such a way that if i pass start date and end date as parameter , something like my... (2 Replies)
Discussion started by: rohit_shinez
2 Replies

2. UNIX for Dummies Questions & Answers

Trying to configure DNS using BIND package in Oracle Linux 6.6

Version: Oracle Linux 6.6 I am trying to set up DNS for forward and reverse lookups. I am new to BIND package. I have installed the following packages. bind (includes DNS server, named) bind-utils (utilities for querying DNS servers about host information) bind-libs (libraries... (0 Replies)
Discussion started by: kraljic
0 Replies

3. Shell Programming and Scripting

How to call Oracle package in shell file?

How to call oracle package in shell file in my shell file, I have Export SQL FILE =$Home_dir select.sql if I want to add call two function in package how can I do it :( (2 Replies)
Discussion started by: Hscript
2 Replies

4. Red Hat

How to call Oracle package through shell script?

Hey i have a package in oracle to validate file mask. can i call it in through shell script . if yes , how Thanks (1 Reply)
Discussion started by: ramsavi
1 Replies

5. 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

6. 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

7. 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

8. Shell Programming and Scripting

Calling oracle package Unix from shell scripts.

Hi, Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell script. I want to know the way to capture the output values in my shell script. Please send some... (1 Reply)
Discussion started by: anil029
1 Replies

9. Shell Programming and Scripting

Return rows from Oracle package

I need help . I am not getting anything back from my setup. I have defined an oracle package which I am calling from within my sql call, but is returning no rows. If I run my sql from sqlplus works find, does not work whe I try to run from UNIX shell script My korn script test.ksh #!bin/ksh... (6 Replies)
Discussion started by: TimHortons
6 Replies
Login or Register to Ask a Question