getPathInfo()
{
sqlplus -s /nolog <<!!|grep -v 'Connected'
connect ${FCP_LOGIN};
SET HEADING OFF;
SET FEEDBACK OFF;
SET LINESIZE 3000;
SET SERVEROUTPUT ON SIZE 1000000;
BEGIN
DECLARE
value1 VARCHAR2(250) := '';
value2 VARCHAR2(250) := '';
BEGIN
BEGIN
SELECT '10','20'
INTO value1 ,value2
FROM dual;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('NO_DATA_FOUND');
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('ERROR');
END;
DBMS_OUTPUT.PUT_LINE(value1||'#'||value2);
END;
END;
/
!!
}
value=`getPathInfo`
x=`echo "$value"|cut -d# -f1`
y=`echo "$value"|cut -d# -f2`
echo "x : $x“
echo "y : $y“
Output :
x : 10
y : 20
Note : change the select query to fetch the valueset values
A Language is not worth knowing unless it teaches you to think differently.
Subscribe to:
Post Comments (Atom)
Item - Category Query
SELECT msi.segment1 AS Item_Code, msi.DESCRIPTION AS Item_Desc, mcs.CATEGORY_SET_NAME, mck.CONCATENATED_SEGMEN...
-
1. To download Ldt file for a Concurent Program FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_nam...
-
The profile information available in the HZ_CUSTOMER_PROFILES can be created in three levels namely Party, Customer Account and Customer...
-
Here the article will describe about how to register WebADI to Responsibility menu Go to System Administrator --> Security --> Respo...
No comments:
Post a Comment