Error in script

ancys — Mon, 31 Jul 2006 04:29:15 GMT

hi,

I wrote unix shell program(bash) which in turn executes two sql statements
TaBLE STRUCTURE
Employee
criteriano project
ctr2 update table1 set empname='arun' where empid=1

SCRIPT
#!bin/sh
/oraclepath username/password<
update employee
set sal=sal+2000;
commit;

DECLARE result employee.project%TYPE;
i NUMBER DEFAULT 0;
j NUMBER;
BEGIN
SELECT COUNT(*) INTO j FROM employee WHERE EXISTS(SELECT * FROM employeeWHERE CRITERIANO='Crt2');
IF(j>0) THEN
DECLARE CURSOR cursorname IS SELECT * FROM employee WHERE criteriano='Crt2';
BEGIN
FOR navcursor IN cursorname
LOOP
i:=i+1;
result:=navcursor.project;
EXECUTE IMMEDIATE result;
dbms_output.put_line('Look Ma, I can print from PL/SQL!!!');

COMMIT;
END LOOP;
END;
ELSE
dbms_output.put_line('Look Ma, I can print from PL/SQL!!!');

END IF;
END
EOF

Both query gets execute successfully in query analyser
But when used in unix script 1st query gets executed not the second(i.e) cursor.
Its not able to read the cursor
I need both the query to be executed when i run the script

How to solve this
Help me

Re: Error in script

Jonathan Fife — Mon, 31 Jul 2006 09:27:30 GMT

What error is it giving you? How do you know it is "not able to read the cursor"?

Also, is that the actual contents of your script?

Re: Error in script

ancys — Mon, 31 Jul 2006 23:08:33 GMT

hi

Any sql statements(insert or update or delete or cursor concept) which is placed after the update statement is not getting executed.

The concept is for given criteriano there can multiple project i need to navigate through the records for given criteria no

Help Please!!!

topic Re: Error in script in Operating System - Linux

Error in script

Re: Error in script

Re: Error in script