Shell Programming and Scripting

echo "
SET SERVEROUT ON SIZE 100000
SET FEED OFF
DECLARE 
  var_px_cat number:=0;
BEGIN
DBMS_OUTPUT.enable(1000000);
SELECT COUNT(*) INTO var_px_cat
FROM A 
WHERE B = '$CATEGORIE_ID';
DBMS_OUTPUT.PUT(var_px_cnr);
DBMS_OUTPUT.NEW_LINE;
END;
/
 " | sqlplus user/pswd@someplace  | read myvar
echo "myvar is now $myvar"

#! /bin/ksh

aaa=`sqlplus -s username/password@sid <<END >outputfile.txt
SET SERVEROUTPUT ON;
DECLARE
var_px_cat number;
BEGIN
SELECT COUNT(1) 
INTO var_px_cat
FROM A
WHERE B='$CATGORIE_ID';
DBMS_OUTPUT.PUT_LINE (var_px_cat);
END;
/
exit;
END`

a=`head -1 outputfile.txt`

echo $a

...
count=`sqlplus -s username/password@sid <<EOF
set pages 0 feed off
SELECT COUNT(*)||''
FROM A 
WHERE B = '$CATEGORIE_ID';
exit
EOF`
echo "Count = $count"
...