Shell Programming and Scripting

Hi,
My requirement is to load a LONG datatype data value from one table to another as direct access does not work (DB: ORACLE).
eg.

Code:

SELECT *FROM ALL_VIEWS WHERE TEXT LIKE '%<SEARCH_STRING>%';

As an alternate we are creating a table and trying to insert in it from ALL_VIEWS as direct insert stmt does not work.

Code:

create table myviews(
OWNER     VARCHAR2(150),
VIEW_NAME VARCHAR2(90),
TEXT      CLOB 
);

so we are using an anonymous block to insert the data in myviews :

Code:

begin
for i in (select owner, view_name, text from all_views) 
loop
insert into myviews values (i.owner, i.view_name, i.text);
end loop;
end;

the above stmt works fine on sql prompt but does not respond well through shell script, though no syntax error is caught.
Is there anyway i can select directlt data from ALL_VIEWS
OR
solution to above anonymous block ?
Kindly assist. any help is appreciated.

Please post the complete script and the exact output/error that you're getting.

In the topic below you will find some ways to execute sqlplus:
-----> https://www.unix.com/shell-programming-scripting/171799-component-pak_popl_suppl-must-declared-error.html

Specifically this post!

I hope it helps!