Dynamic sql in inserting data !!!!!

From: <kamlesh.kumar_at_churchill.co.uk>
Date: Sat, 22 Jan 2000 14:58:37 GMT
Message-ID: <86cgio$u7a$1@nnrp1.deja.com>

Hi All

I have some problem with dynamic sql in case off inserting data in a table . I wants to use a ver.
But giving error like this :-

DECLARE

str                VARCHAR2(100);
cid                number ;
feed               number;
field              varchar2(20);

begin
field := 'Kamalesh';
 str:= 'insert into tmp values ('||field||')'; cid := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cid,str ,dbms_sql.v7);
feed := DBMS_SQL.EXECUTE(cid);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Err '||sqlerrm);
end;

Err ORA-00984: column not allowed here

Please let me know what can i do in this case .

Thanks
Kamalesh

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jan 22 2000 - 08:58:37 CST