I'm not sure if this will result in a database NULL or the string "NULL". You might have better luck just leaving it as "$1" and seeing if the resulting "" is interpreted as a database NULL.
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Hello All,
I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script.
I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable).
But, what if we want to return multiple values?
One option I... (4 Replies)
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
hi,
Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable...
Thanks in advance... (5 Replies)
Hi All ,
I am trying to pass a value from sqlplus to korn shell .
There is a table tab1 in Oracle that has a column userdate.
I need to pass the userdate to the korn shell . This is what I am doing .
VALUE=`sqlplus -silent username/password << END
set pagesize 0 feedback off verify off... (14 Replies)
Hi scripting experts.
I have some coding challenges that I'm hoping you can help me out.
I have one file#1 that contains the following sql statement that spans over multiple lines:
sql Select /*+ use_has(a,b) */ *
from customer a,
customer_address b
where a.id = b.id... (1 Reply)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
I have written a script which will take input parameter as another script.
However, if the script passed as input parameter has parameters then this script doesn't work.
I have a script b.ksh which has 1 and 2 as parameters
I have a script c.ksh which has 3,4 and 5 as parameters
vi a.ksh... (1 Reply)
Discussion started by: Vee
1 Replies
LEARN ABOUT ULTRIX
xrmputlineresource
XrmPutResource(3X11) MIT X11R4 XrmPutResource(3X11)Name
XrmPutResource, XrmQPutResource, XrmPutStringResource, XrmQPutStringResource, XrmPutLineResource - store database resources
Syntax
void XrmPutResource(database, specifier, type, value)
XrmDatabase *database;
char *specifier;
char *type;
XrmValue *value;
void XrmQPutResource(database, bindings, quarks, type, value)
XrmDatabase *database;
XrmBindingList bindings;
XrmQuarkList quarks;
XrmRepresentation type;
XrmValue *value;
void XrmPutStringResource(database, specifier, value)
XrmDatabase *database;
char *specifier;
char *value;
void XrmQPutStringResource(database, bindings, quarks, value)
XrmDatabase *database;
XrmBindingList bindings;
XrmQuarkList quarks;
char *value;
void XrmPutLineResource(database, line)
XrmDatabase *database;
char *line;
Arguments
bindings Specifies a list of bindings.
database Specifies the resource database.
line Specifies the resource name and value pair as a single string in the valid ResourceLine format. A single colon (:) separates the
name from the value. Note that comment lines are not stored.
quarks Specifies the complete or partial name or the class list of the resource.
specifier Specifies a complete or partial specification of the resource.
type Specifies the type of the resource.
value Specifies the value of the resource, which is specified as a string.
Description
If database contains NULL, creates a new database and returns a pointer to it. is a convenience function that calls followed by:
XrmQPutResource(database, bindings, quarks,
XrmStringToQuark(type), value)
If database contains NULL, creates a new database and returns a pointer to it.
If database contains NULL, creates a new database and returns a pointer to it. adds a resource with the specified value to the specified
database. is a convenience function that first calls on the specifier and then calls using a ``String'' representation type.
If database contains NULL, creates a new database and returns a pointer to it. is a convenience routine that constructs an for the value
string (by calling to compute the size) and then calls using a ``String'' representation type.
If database contains NULL, creates a new database and returns a pointer to it. adds a single resource entry to the specified database.
Any white space before or after the name or colon in the line argument is ignored. The value is terminated by a new-line or a NULL charac-
ter. To allow values to contain embedded new-line characters, a ``
'' is recognized and replaced by a new-line character. For example,
line might have the value ``xterm*background:green
''. Null-terminated strings without a new line are also permitted.
To allow values to contain arbitrary octets, the 4-character sequence
nn, where n is a digit in the range of "0"-"7", is recognized and
replaced with a single byte that contains this sequence interpreted as an octal number. For example, a value containing a NULL byte can be
stored by specifying "