4 Replies Latest reply: Dec 1, 2013 4:15 PM by rp0428 RSS

    Having trouble in SQL dev with a procedure.

    Xev Bellringer

      Hey guys, Having trouble with the.following Pl SQL procedure. Is this code wrong?


      create table zed ( z varchar2(30);




      procedure thisway1 (p_data in varchar2 )



                  execute immediate

                   'insert into zed(z) values(:z)'

                    using p_data;

                     end thisway1;


      ok, ive tried over and over, what is missing from this code?

      Its from a book, so its supposed to work...