Sponsored Content
Full Discussion: invoke oracle package error?
Top Forums Shell Programming and Scripting invoke oracle package error? Post 302219443 by andrewknight on Tuesday 29th of July 2008 06:12:11 AM
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!
 

9 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

9. 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
pwd.h(3HEAD)                                                          Headers                                                         pwd.h(3HEAD)

NAME
pwd.h, pwd - password structure SYNOPSIS
#include <pwd.h> DESCRIPTION
The <pwd.h> header provides a definition for struct passwd, which includes the following members: char *pw_name user's login name uid_t pw_uid numerical user ID gid_t pw_gid numerical group ID char *pw_dir initial working di rectory char *pw_shell program to use as shell The gid_t and uid_t types are defined as described in <sys/types.h>. See types.h(3HEAD). ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Standard | +-----------------------------+-----------------------------+ SEE ALSO
getpwnam(3C), types.h(3HEAD), attributes(5), standards(5) SunOS 5.10 10 Sep 2004 pwd.h(3HEAD)
All times are GMT -4. The time now is 10:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy