hai,
can anybody say how to call or to execute an oracle stored procedure in oracle from unix...
thanks in advance.... for ur reply....
by,
leo (2 Replies)
how to
1) invoke batch profile to run sqlplus on XXXXX server.
2) execute truncate table xtra.xtra_card_email_request using procedure dbadmin.truncate_table .
3) Check the count before and after the job run. (1 Reply)
Hi All,
I want to call a concurrent request set from a shell script. I am getting the syntax error "syntax error at line 417 : `(' unexpected" in the below script.
v_request_id=fnd_request.submit_request(application => 'APPL_SHORT_NAME'
,program => 'PROGRAM_SHORT_NAME'
... (4 Replies)
hi there
I have a view which is working fine, but i have been told that i need to make sure the resulting output excludes all rows with nic_status equal to the string "removed".
Does anybody know in which part of the code below i would place the conditional ...
WHERE nic_status !=... (4 Replies)
Hi All,
I need to call a java method from a shell script. I know we can use the command
java ClassName
to call the main method in it. But I need to call another method that is there in the class and pass an email to it.
Can I use
java ClassName.MethodName(email)
Any help will be... (4 Replies)
I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible?
if yes just give me an example for doing that. (2 Replies)
Hello Experts,
I have the following questions to be discussed here at this esteemed discussion forum.
I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of... (1 Reply)
Hi all, I just signed up to the forums, although, I have lurked on here for awhile. Anyways, my issue is I am trying to get awk to spit out something I can use without having to spend hours in excel hell haha. So, I used sed to replace the spaces with semicolons and redirected that to a file. ... (6 Replies)
Hello All,
I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below.
cat > $v_Input_File 2>>$v_Log << EOF
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16';
EXECUTE... (1 Reply)
Hello All,
I have exactly same issue @vikas_trl had in following link:
https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would... (4 Replies)
Discussion started by: RicardoQ
4 Replies
LEARN ABOUT OPENSOLARIS
scsi_setup_cdb
scsi_setup_cdb(9F) Kernel Functions for Drivers scsi_setup_cdb(9F)NAME
scsi_setup_cdb - setup SCSI command descriptor block (CDB)
SYNOPSIS
int scsi_setup_cdb(union scsi_cdb *cdbp, uchar_t cmd, uint_t addr,
uint_t cnt, uint_t othr_cdb_data);
INTERFACE LEVEL
Solaris DDI specific (Solaris DDI).
PARAMETERS
cdbp Pointer to command descriptor block.
cmd The first byte of the SCSI group 0, 1, 2, 4, or 5 CDB.
addr Pointer to the location of the data.
cnt Data transfer length in units defined by the SCSI device type. For sequential devices cnt is the number of bytes. For
block devices, cnt is the number of blocks.
othr_cdb_data Additional CDB data.
DESCRIPTION
The scsi_setup_cdb() function initializes a group 0, 1, 2, 4, or 5 type of command descriptor block pointed to by cdbp using cmd, addr,
cnt, othr_cdb_data.
addr should be set to 0 for commands having no addressing information (for example, group 0 READ command for sequential access devices).
othr_cdb_data should be additional CDB data for Group 4 commands; otherwise, it should be set to 0.
The scsi_setup_cdb() function does not set the LUN bits in CDB[1] as the makecom(9F) functions do. Also, the fixed bit for sequential
access device commands is not set.
RETURN VALUES
The scsi_setup_cdb() function returns:
1 Upon success.
0 Upon failure.
CONTEXT
These functions can be called from a user, interrupt, or kernel context.
SEE ALSO makecom(9F), scsi_pkt(9S)
Writing Device Drivers
American National Standard Small Computer System Interface-2 (SCSI-2)
American National Standard SCSI-3 Primary Commands (SPC)
SunOS 5.11 16 Jan 2006 scsi_setup_cdb(9F)