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

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
asadmin-delete-instance(1AS)					   User Commands				      asadmin-delete-instance(1AS)

NAME
delete-instance - deletes the instance that is not running. SYNOPSIS
delete-instance [--user admin_user] [--password admin_password] [--host localhost] [--port 4848] [--local=false] [--domain domain_name] [--passwordfile filename] [--secure|-s]instance_name Use the delete-instance command to delete the instance that you specify. The delete-instance command can be run both locally and remotely. To delete the instance locally, not requiring the administration server to be up and running, specify the --local option. To delete the instance remotely, the administration server must be running on the hostname and port number specified. The user authenticates using the password identified for the administration server. Additionally, the instance must already exist within the domain served by the adminis- tration server. Use this command with discretion since it is destructive and there is no undo. OPTIONS
--user administrative user associated for the instance. --password administrative password corresponding to the administrative user. --host host name of the machine hosting the administrative instance. --port administrative port number associated with the administrative host. --domain name of the domain. --local determines if the command should delegate the request to administrative instance or run locally. --passwordfile file containing passwords appropriate for the command (e.g., administrative instance). --secure if true, SSL/TLS to communicate with the administrative instance. OPERANDS
instance_name name of the instance to be deleted. Example 1: Using delete-instance in local mode asadmin> delete-instance --domain domain1 server1 Deleted Instance server1 successfully Where: the server1 instance for the domain1 domain is deleted on the local machine. Example 2: Using delete-instance in remote mode asadmin> delete-instance --user admin --passwordfile passwords.txt --host localhost --port 4848 server1 Deleted Instance server1 successfully Where: the server1 instance for the domain associated with the specified user, passwords in the password file, host, and port number is deleted on the remote machine. EXIT STATUS
0 command executed successfully 1 error in executing the command INTERFACE EQUIVALENT
Server Instance page asadmin-create-instance(1AS), asadmin-start-instance(1AS), asadmin-stop-instance(1AS), asadmin-restart-instance(1AS) J2EE 1.4 SDK March 2004 asadmin-delete-instance(1AS)
All times are GMT -4. The time now is 12:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy