Sponsored Content
Top Forums Shell Programming and Scripting Parsing Comma Separated values to UNIX variable from PLSQL Post 303018907 by panyam on Tuesday 19th of June 2018 02:00:30 AM
Old 06-19-2018
Hi Mahesh,

Can you post the output of below command:

Code:
sqlplus -s /nolog <<ENDSQL|grep -v 'Connected'>$LOG_FILE
connect $FCP_LOGIN
set feedback off
set heading off
set serveroutput on
declare
mavar1 varchar2(400);
begin
pack_list_print_pkg.get_cust_mail_address($param1,$param2,mavar1);
dbms_output.put_line('CUSTMAIL-ADDRESS'||mavar1);
end ;
/
ENDSQL

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting comma separated values into an array

I'm attempting to create a KSH array out of a string like this: ",,,value1,value2,," I have created the array but I only get two elements, one for value1 and one for value2. I have ended up with something like this but I don't like it: set -A JUNK xx=0 for i in $(print ",,,value1,value2,,"... (3 Replies)
Discussion started by: tmarikle
3 Replies

2. Shell Programming and Scripting

Extracting the values separated by comma

Hi, I have a variable which has a list of string separated by comma. for ex , Variable=/usr/bin,/usr/smrshbin,/tmp How can i get the values between the commas separately using shell scripts.Please help me. Thanks, Padmini. (6 Replies)
Discussion started by: padmisri
6 Replies

3. Shell Programming and Scripting

Parsing Comma separated Arguments

Hi unix guru's I want to execute a shell script like ksh printdetails.ksh Andy,Bob,Daisy,Johnson like passing all the four names in the as the arguments and these arguments are varies between 1 to 10. How to pass these names to the shell script variable. and also i want to know the count... (4 Replies)
Discussion started by: Reddy482
4 Replies

4. Shell Programming and Scripting

parsing comma separated file

Hi, I have a file with th elist of patches separated by comma, like below: patch1, patch 2, patch 3................ t\The number of patches is not known as it changes every time. I need assistance in writing a routine such as it will take patch1 as first variable and performs the... (4 Replies)
Discussion started by: avikaljain
4 Replies

5. Shell Programming and Scripting

Parsing and filtering multiline text into comma separated line

I have a log file that contains several reports with following format. <Start of delimiter> Report1 header Report1 header continue Report1 header continue Record1 header Record1 header continue Record1 header continue field1 field2 field3 field4 ------... (1 Reply)
Discussion started by: yoda9691
1 Replies

6. Shell Programming and Scripting

To agregate Comma separated values

Hi pls help me to get the code: i have a file in which content is : 2.01304E+11 2.01304E+11 ori 2 01:00 2.01304E+11 2.01304E+11 ori 2 01:02 2.01304E+11 2.01304E+11 ori 3 01:02 2.01304E+11 2.01304E+11 ori 3 ... (7 Replies)
Discussion started by: Aditya.Gurgaon
7 Replies

7. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

8. Shell Programming and Scripting

Needs help in parsing comma separated values

hello experts, i am retrieving values in variables jobKey and jobName within my shell script. these values are returned to me within braces and i am using following command to remove those braces: jobKeys=`echo $jobKeys | sed 's:^.\(.*\).$:\1:'` jobNames=`echo $jobNames | sed... (1 Reply)
Discussion started by: avikaljain
1 Replies

9. Shell Programming and Scripting

Comma separated values to individual lines

My OS : RHEL 6.7 I have a text file with comma separated values like below $ cat testString.txt 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', . . . . I want these values to appear like below 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', .... (4 Replies)
Discussion started by: kraljic
4 Replies

10. Shell Programming and Scripting

Assign comma separated values to a variable

Hi All, I wrote a database command that queries our application and outputs a whole bunch of values to a text file. I need to assign the output to two values. Here is a sample of the output: valueOne, checkOne valueTwo, checkTwo valueThree, checkThree I would like... (9 Replies)
Discussion started by: jeffs42885
9 Replies
fmtmsg(1)							   User Commands							 fmtmsg(1)

NAME
fmtmsg - display a message on stderr or system console SYNOPSIS
fmtmsg [-c class] [-u subclass] [-l label] [-s severity] [-t tag] [-a action] text DESCRIPTION
Based on a message's classification component, the fmtmsg utility either writes a formatted message to stderr or writes a formatted message to the console. A formatted message consists of up to five standard components (see environment variable MSGVERB in the ENVIRONMENT VARIABLES section of this page). The classification and subclass components are not displayed as part of the standard message, but rather define the source of the message and direct the display of the formatted message. OPTIONS
The following options are supported: -c class Describes the source of the message. Valid keywords are: hard The source of the condition is hardware. soft The source of the condition is software. firm The source of the condition is firmware. -u subclass A list of keywords (separated by commas) that further defines the message and directs the display of the message. Valid keywords are: appl The condition originated in an application. This keyword should not be used in combination with either util or opsys. util The condition originated in a utility. This keyword should not be used in combination with either appl or opsys. opsys The message originated in the kernel. This keyword should not be used in combination with either appl or util. recov The application will recover from the condition. This keyword should not be used in combination with nre- cov. nrecov The application will not recover from the condition. This keyword should not be used in combination with recov. print Print the message to the standard error stream stderr. console Write the message to the system console. print, console, or both may be used. -l label Identifies the source of the message. -s severity Indicates the seriousness of the error. The keywords and definitions of the standard levels of severity are: halt The application has encountered a severe fault and is halting. error The application has detected a fault. warn The application has detected a condition that is out of the ordinary and might be a problem. info The application is providing information about a condition that is not in error. -t tag The string containing an identifier for the message. -a action A text string describing the first step in the error recovery process. This string must be written so that the entire action argument is interpreted as a single argument. fmtmsg precedes each action string with the TO FIX: prefix. text A text string describing the condition. Must be written so that the entire text argument is interpreted as a single argu- ment. EXAMPLES
Example 1: Standard message format The following example of fmtmsg produces a complete message in the standard message format and displays it to the standard error stream. example% fmtmsg -c soft -u recov,print,appl -l UX:cat -s error -t UX:cat:001 -a "refer to manual" "invalid syntax" produces: UX:cat: ERROR: invalid syntax TO FIX: refer to manual UX:cat:138 Example 2: Using MSGVERB When the environment variable MSGVERB is set as follows: MSGVERB=severity:text:action and Example 1 is used, fmtmsg produces: ERROR: invalid syntax TO FIX: refer to manual Example 3: Using SEV_LEVEL When the environment variable SEV_LEVEL is set as follows: SEV_LEVEL=note,5,NOTE the following fmtmsg command: example% fmtmsg -c soft -u print -l UX:cat -s note -a "refer to manual" "invalid syntax" produces: NOTE: invalid syntax TO FIX: refer to manual and displays the message on stderr. ENVIRONMENT VARIABLES
The environment variables MSGVERB and SEV_LEVEL control the behavior of fmtmsg. MSGVERB is set by the administrator in the /etc/profile for the system. Users can override the value of MSGVERB set by the system by resetting MSGVERB in their own .profile files or by changing the value in their current shell session. SEV_LEVEL can be used in shell scripts. MSGVERB tells fmtmsg which message components to select when writing messages to stderr. The value of MSGVERB is a colon-separated list of optional keywords. MSGVERB can be set as follows: MSGVERB=[keyword[:keyword[:...]]] export MSGVERB Valid keywords are: label, severity, text, action, and tag. If MSGVERB contains a keyword for a component and the component's value is not the component's null value, fmtmsg includes that component in the message when writing the message to stderr. If MSGVERB does not include a keyword for a message component, that component is not included in the display of the message. The keywords may appear in any order. If MSGVERB is not defined, if its value is the null string, if its value is not of the correct format, or if it contains keywords other than the valid ones listed above, fmtmsg selects all components. MSGVERB affects only which message components are selected for display. All message components are included in console messages. SEV_LEVEL defines severity levels and associates print strings with them for use by fmtmsg. The standard severity levels shown below cannot be modified. Additional severity levels can be defined, redefined, and removed. 0 (no severity is used) 1 HALT 2 ERROR 3 WARNING 4 INFO SEV_LEVEL is set as follows: description is a comma-separated list containing three fields: SEV_LEVEL= [description[:description[:...]]] export SEV_LEVEL description=severity_keyword, level, printstring severity_keyword is a character string used as the keyword with the -s severity option to fmtmsg. level is a character string that evaluates to a positive integer (other than 0, 1, 2, 3, or 4, which are reserved for the standard severity levels). If the keyword severity_keyword is used, level is the severity value passed on to fmtmsg(3C). printstring is the character string used by fmtmsg in the standard message format whenever the severity value level is used. If SEV_LEVEL is not defined, or if its value is null, no severity levels other than the defaults are available. If a description in the colon separated list is not a comma separated list containing three fields, or if the second field of a comma separated list does not eval- uate to a positive integer, that description in the colon separated list is ignored. EXIT STATUS
The following exit values are returned: 0 All the requested functions were executed successfully. 1 The command contains a syntax error, an invalid option, or an invalid argument to an option. 2 The function executed with partial success, however the message was not displayed on stderr. 4 The function executed with partial success; however, the message was not displayed on the system console. 32 No requested functions were executed successfully. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ SEE ALSO
addseverity(3C), fmtmsg(3C), attributes(5) SunOS 5.10 20 Jul 1994 fmtmsg(1)
All times are GMT -4. The time now is 10:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy