Re: Dynamic sql in inserting data !!!!!

str:= 'insert into tmp values ('''||field||''')';

Hth,

--
Sybrand Bakker, Oracle DBA
<kamlesh.kumar_at_churchill.co.uk> wrote in message news:86cgnf$u9c$1_at_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 - 09:18:34 CST